Need to get info from on table to another when new form loads

[Dave14867]

Hello all,


I am fairly new to all this and trying to create a database to assist me at work. I have 3 tables created, hopefully correctly,. When I have the "Instrument Info Form" open and click on the "Log Issue" Command button, the "Issue Log Form" opens to enter a new record. I want the "Instrument ID" that was active when the Command button was clicked to be carried over and populated and also the "Instrument_Serial_Num" from the "Instrument Info Form"

I have attached the file so you can take a look at it.

Please be kind, I am new at this and trying to learn.

Thanks

DaveWet Run History - 3.zip

[Bob Fitz]

You use the wizard to create a subform on the form called "Instrument Info Form". The subform control would use your existing form "Issue Log Form". the "Instrument ID" fields would be populated automatically, maintaining your one to many relationship. As you have this relationship between the tables there should be no need to repeat data in the second table.

[Dave14867]

Bob,
I want to keep the 3 separate form for now. I have tried DLOOKUP but I can't seem to get that to work for some reason. Can you help me out using that method?

Thanks
Dave

[Bob Fitz]

You could open the form using:

DoCmd.OpenForm "Issue Log Form", , , , , , Me.Instrument_ID

This would pass the Instrument_ID value to the forms OpenArgs property which could then be referenced by the second form

[Dave14867]

I will try that,

Thanks

Dave