Forms not properly linked to table

[gafort]

I have a simple contact database with one table. Form one shows contact information, website, facebook, etc. I made a second form for additional information so the first form wasn't too crowded. All fields from both forms are in the one table. To go from form 1 to form 2 I have a button with the following code:

Private Sub Questions_Click()


DoCmd.OpenForm "Questions", acNormal
DoCmd.Close acForm, Me.Name
End Sub

When I enter values into form two they remain for all records in form one. The values should be specific for each recordset in form one. Am I missing something to link the two forms together?

[pbaldy]

Well, this would open the second form to the same record:

http://www.baldyweb.com/wherecondition.htm

but personally I'd use a tab control and have everything on one form.

[gafort]

I like the look and feel of a tab control better anyway. Thanks for that. I dropped form one and form two on the navigation form and still have the same problem. When I'm on record one and switch to tab two and enter any information, that information is now on ALL records, not just record one. Form one has contact information of auto dealers and form two has specific information about their dealership. It is all on one table. Something is not connecting.

[pbaldy]

If you're seeing the same info for all records, it sounds like the text boxes are not bound to fields in the table.

[gafort]

OK I see something I didn't before. The information entered into form two is correct, it is the form two record not staying on the same as in form one. If I am on form one record 10 and click form two, how do I keep it on record 10. When I click form two, I am back to record one. I think that is my problem

[pbaldy]

That is one reason I'd use a single form with a tab control. If you want to use two forms, you'll need code to keep them in sync. It would use a variation of this:

http://www.baldyweb.com/Bookmark.htm

[gafort]

OK, now I'm a little confused. Are you saying use the same form twice and just remove controls you don't want to see?

[pbaldy]

I've said "one form" and "a single form". I'm not sure how to say it any clearer. One form with a tab control, not two forms.

[gafort]

Paul, that's what I'm using, one form. I took one form, Car Dealers and dragged it to tab #1. How do I get additional information on tab #2? Tab #2 shows "Add New". If I click on it, it shows an unbound form. That's where it is not making sense to me.

[pbaldy]

Dragging one form to another created a subform. I think you'd be better served by starting fresh with a blank new form. Add a tab control to it, bind it to the table, then add controls (text boxes, combo boxes, etc) to each tab as appropriate.

[gafort]

Sorry for the trouble, I was trying to use a tabbed navigation control by mistake. I think I have it figured out now. Thanks

[pbaldy]

No problem, post back if you get stuck.