two forms, same record

[stacy]

I have a rather large table (not too large, just a little hard to navigate). I have set up a form to fill out the table, but it's still a little too big to use easily as well. I was thinking of using macros to open additional forms that could save to the same record. I've got the second form opening alright, but it keeps saving the forms as two new records.

I found a similar entry under a different newsgroup where it was advised to use VisualBasic code. Even using VB, I could only get the files to save in two different records. (Considering I know NOTHING about VB, I considered even this to be a major accomplishment.

 

[Steve Schapel]

Stacy,

First of all, great idea to use a form for your data entry/viewing
processes. Tables should never be used for this purpose anyway.

Rather than trying to use more than one form to access the same record,
maybe you could consider this... Just use one form bound to your table.
If you put a Tab Control on your form, you will be able to put some
fields on each of several pages of the tab control, group them together
so they relate to similar "type" of information, so all you need to do
to access different parts of the same record is flip between the tabs.