New record on child form opens without linked data

J

John F.

Hi:

I have two forms constructed by FormWizard from two tables linked by the
field, 'RecNum' (which has the same name and data type and length, etc on
master and chld tables). The child form opens fine and presents the 'many'
data fields as expected. However, when I click on the 'New Record' button on
the navigator on the child form, it opens the new record without
automatically filling in the 'RecNum' field (and textbox). Shouldn't it do
this automatically for the 'master-child' linking field? How do I fix this
anomalous behaviour (preferably without using VBA)?

Thank you.

John f.
 
R

Rick Brandt

John said:
Hi:

I have two forms constructed by FormWizard from two tables linked by
the field, 'RecNum' (which has the same name and data type and
length, etc on master and chld tables). The child form opens fine and
presents the 'many' data fields as expected. However, when I click on
the 'New Record' button on the navigator on the child form, it opens
the new record without automatically filling in the 'RecNum' field
(and textbox). Shouldn't it do this automatically for the
'master-child' linking field? How do I fix this anomalous behaviour
(preferably without using VBA)?

It might pick the value up when you save even though it is not displayed
prior to that. I say "might" because in my subforms the linking fields are
never displayed in the subform so I can't recall just how they behave. The
behavior you're describing is how default values work, but I'm not sure
thats how linking fields work in Parent/Subforms.

Have you tried actually finishing a new record and moving off of it to see
what happens?
 

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

Top