Subforms without link fields - Will this cause problems?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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).
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Locked Subform still lets me delete a record 2
Add primary key dynamically to a subform within subform from the 10
How can I link form/subform in code? 2
Main form Combobox and subform 2
Access Daily Entry with multiple entries per field 0
Master Child link being broken. 1
Comparing data from a subform and form 1
Populate a field based on a visible value in a combo box? 2

Back
Top