Control Source or SetValue or Default Value

[Nata]

I have a form that has a list of clients. I have another form that will record orders of clients.
So I want it so that when I click on New Order button it automatically records the ID of the client who places the order, so that it's attached to his record.
I have tried setting Default Value to ID from CLIENTS form, and setting Default Value to DLookup and then whatever (I'm not a coder, so I might have messed up there), then tried creating a macro and use SetValue, and nothing works.
Any ideas?

 

[alxj]

I think that you are on slightly the wrong track.
Go back to the basics.
If you have a table with your clients in and a table for the orders to go into then relate the two tables together then use the form wizard to create a simple form with subform.
Use the example northwind database to help you.

 

[Nata]

Thanks
But it won't let me. My form is set to Continous forms (and that's what I need it to be), and therefore it says I can't have a subform on continuous form.
So I'm looking for a workaround.
When I try to put subform on it it gives me that error message, and then still puts the form there. Property set to UNBOUND though.
So I don't know what that means, is it usable or no.

 

[Nata]

But what you said about relating is good.

I already have both forms made. How can I connect them at this point to work with each other.