Open a form using a command button to display a specific record

[getoboy]

Greetings all!

Captain newbie here! I am attempting to open a form using a command button which will display a specific record specified by the value of a control on another form.

I currently have 1 table with many field names. To compensate, I use 2 forms which correspond to each record stored within the table (too many fields for 1 form). I have created a command button on "form 1" which opens "form 2." I have used the command button wizard to link the 2 forms using a common control field (Customer ID).

The button works ok, and maintains referential integrity, but allows the user to input additional records using "form 2"- which in effect creates a new record in the table.

How do I prevent additional records from being created using "form 2?" Essentially, I want to be able to input data on "form 1" then input additional data (which relates to the same record in the table) using "form 2." Only "form 1" should allow for the addition of new records to the table.

I have tried changing the "Allow Additions" setting on "form 2" to "no," but this displays a blank screen whenever I click the command button which displays "form 2."

Thank you for taking the time to read my post. Your input would be greatly appreciated.

Regards,

Getoboy

 

[nickjar2]

This is probably not what u r after, but have u thought about sticking to the ONE form, but creating a tab control (i think this is what it is called). This form could then have 2 pages. Hope this is ok. If not, just let me know.

Nick (Everton Rool OK!)

 

[getoboy]

Greetings nickjar2:

Thank you for your prompt response. I have investigated the "tab control" you discuss and believe this will work.
However, I have spent alot of time creating "form 2" and would like to use the control button discussed above to access the form.

Any additional ideas?

Thank you,

Getoboy