Save CustomerID used in one Form to another Forms table

[Modify_inc]

I currently have a form for adding customers, and it works fine. I have added a command button to the customer form that when clicked, opens a new form (Devices) for adding a new device that I want to assign to that customer. Yet that is where my problem is, I cannot get the Devices form to save the previous customer record ID to the Devices table.

How do I tell Access that the Devices form is still part of the Customers form or linked to it, and that when I save the new device entires, to add that customers ID to the Device table? Of course I could add a customer search on the Devices form, but that would be redundant as seeing the Devices form is loaded initially from the Customers form via the command button.

I admit, I 'm still learning, but I would love to figure this out.

Thanks
Mike

[June7]

Have you considered a form/subform arrangement? No code would be required.

Opening a dependent record on an independent form requires code that passes the ID value to the form.

Review this thread for one poster's experience https://www.accessforums.net/forms/h...tml#post210672

[Modify_inc]

Have you considered a form/subform arrangement? No code would be required.

Opening a dependent record on an independent form requires VBA code that passes the ID value to the form.

Review this thread for one poster's experience https://www.accessforums.net/forms/h...tml#post210672

Thanks for the advice!
No I didn't. That might be the simplest route.
Thanks for the link, I will check it out also.

Mike

[Modify_inc]

Well no luck...Apparently Access doesn't allow you to use split forms in a subform.

It never fails for me.

Thanks for the suggestion.

[June7]

I've never used the Split form. Looked at, never fits my requirements.

[Modify_inc]

Can I do this:

Create a command button on my customers form to view devices for current customer? I know how to create it to view all devices created, but how do I just tell it to only view current customer's devices?

Thanks
Mike

[June7]

Certainly. Options:

1. dynamic parameterized query as form RecordSource, criteria references ID field/control on Customer form

2. code opens form filtered to ID value, I use only VBA but macro has equivalent
DoCmd.OpenForm "Devices", , , "CustID=" Me.ID

[Modify_inc]

Certainly. Options:

1. dynamic parameterized query as form RecordSource, criteria references ID field/control on Customer form

2. code opens form filtered to ID value, I use only VBA but macro has equivalent
DoCmd.OpenForm "Devices", , , "CustID=" Me.ID

I understand step two, but you lost me in step one.

I understand a little bit about the query used in the RecordSource for the form and how to modify it, but I do not understand or know how to create one for the command button.

I am assuming that is what you are saying that I need to do, correct?

Also using the code you provided resulted in a Compile Error, Expected: end of statement

Doesn't that usually mean a line terminator or similar is missing?

[June7]

Sorry, missing & to concatenate the string and the variable.

DoCmd.OpenForm "Devices", , , "CustID=" & Me.ID

I never use option 1 anyway.