Bring up records linked to specific field on a form using a comand button

[ledis]

hi, i will have to explain this with screen shots. So lets say i have a Customer form which has an ID, NAME & PHONE field. I want to use a button on that field to open another form called Bikes which will be linked to the ID field of the customer so he can have more than one bike to his record. like a sub form but opened in a new form.
I have the relations set up as one to many, i hope the Ss help
1.2.3.

[June7]

A form/subform arrangement is the simplest approach. Opening a related form independently and populating the foreign key customer_ID field can be accomplished several ways.

One is to set the DefaultValue property of the customer_ID field on the Bikes form to: Forms!Customer!ID. Then manually move to new record row or use code to move or even have the form open directly to new record row.

[ledis]

A form/subform arrangement is the simplest approach. Opening a related form independently and populating the foreign key customer_ID field can be accomplished several ways.

One is to set the DefaultValue property of the customer_ID field on the Bikes form to: Forms!Customer!ID. Then manually move to new record row or use code to move or even have the form open directly to new record row.

Thank you for your fast reply, but being the novice that i am i don't understand what to do. Not even sure where to start to be honest.

[June7]

Then why don't you use the form/subform approach?

[ledis]

Then why don't you use the form/subform approach?

Yes, i think im going to use the Tab feature. I just thought it would look better with the command buttons. Cause i wanted to have one that goes straight to a new record and that goes to the 1rst on and you navigate through the rest.

[June7]

The more 'user friendly' the more code.

If you want to go straight to new record, will need code (macro or VBA) or set the form to DataEntry property to Yes.