Recent content by cardgunner

  1. cardgunner

    open house db update

    Well I found an solution to Issue2 thru some feedback by Big Jon Booty He had another solution to that I didn't use. you can find the thread here http://www.access-programmers.co.uk/forums/showthread.php?t=210006 This also inadvertenly fixed Issue #1. No more error.
  2. cardgunner

    stop subform datasheet from scrolling to next record!

    This worked great. Thank you very much.
  3. cardgunner

    stop subform datasheet from scrolling to next record!

    Well when I tab out of field other it's supposed to go to field alt_id but it goes to the next field in the tab order. I'm trying to solve an issue I have in a subform where I don't want to go to the next record. I have posted the db and my issues here...
  4. cardgunner

    stop subform datasheet from scrolling to next record!

    I have tried to do this but it doesn't work. My code on the lostfocus event is Private Sub other_LostFocus() Me.alt_id.SetFocus End Sub
  5. cardgunner

    open house db update

    Well I am getting close but not happy. I have created a db where the user will enter who has come to our open house. I created a form for customers that we currently have and another form for new customers. The current customer form, [frm_current_register] is fine. It works how I want it to...
  6. cardgunner

    Open House db

    Thank you. Yes I could, and I might have to. I have been trying different things for days now. I wanted to keep the user on one form. If I can't get a workable solution that keeps them on one form I will add a command button that will open a form where they enter will enter the corrected...
  7. cardgunner

    Open House db

    If it was that simple I would do that. But what about new businesses? What about the corrections to the existing businesses? What about addition info of an existing businesses gathered at the open house? If only existing business where coming it would be alot easier.
  8. cardgunner

    Open House db

    I have been given the task to create a db for our open house where we can record who shows up. We have our current businesses[extend_names], new bussinesses or corrections to be made to our current bussinesses[2011_attendee] and the contacts for both[2011_attendee_contacts] When someone...
  9. cardgunner

    text box values from combo box selection

    I created a unique identifier. In the query I combined the 2 fields together as the unique identifier. that has solved that. Thank you.
  10. cardgunner

    text box values from combo box selection

    In my form a have a combo box. I want 2 text fields to show the column 0 value and the column 4 value of the combobox. I have set the control source of the text boxes to =[Combobox_name].[Column](0) and =[combobox_name].[Column](4). This works untill I have selected a record in my combobox where...
  11. cardgunner

    subform disappears when linked

    Here is what I have upto now.
  12. cardgunner

    subform disappears when linked

    Hmmm. Maybe I'm not doing this right then. I think I need to start from scratch on this one. On the main form I have a combobox that stores the bpid of the selected record. I linked that value to my 1st subform to give me a set of records. That subform is uneditable. This subform1 is using...
  13. cardgunner

    subform disappears when linked

    I think I know the issue which is what you have stated. In my main form is a combo box where I find the record I want and select it. That box shows the [name] field but holds the [bpid] field. the subform looks at that and brings into it that record. I need to add(and hide) the alt_id field in...
  14. cardgunner

    subform disappears when linked

    Well the form and subform share the same recordsource, which is a Union query. And the bpid and alt id are in the same record, different fields.
  15. cardgunner

    subform disappears when linked

    Even the labels won't show?
Back
Top Bottom