Subforms without link fields - Will this cause problems?

S

sisyphus

Hi,

I am using a subform where I need to have the many side of the connecting
field (account) in the main form because the form's primary purpose is to add
new requests.

Many of the requests will have a new account number. So I want to let the
user add the new account number and client info on the same form - in the
subform.

I was having lots of problems because the main form was looking for the
child link field which didn't yet exist. So I unlinked the forms. Is there
any problem in using a subform this way?
 
M

Marshall Barton

sisyphus said:
I am using a subform where I need to have the many side of the connecting
field (account) in the main form because the form's primary purpose is to add
new requests.

Many of the requests will have a new account number. So I want to let the
user add the new account number and client info on the same form - in the
subform.

I was having lots of problems because the main form was looking for the
child link field which didn't yet exist. So I unlinked the forms. Is there
any problem in using a subform this way?
Click to expand...


Nothing wrong with that. You will have to use another
mechanism to keep them synchronized though (Filter or
RecordSource property).
 
Top