Form and Subform

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

Guest

I have a form which shows data in fields fed from a table. I have a subform
which has 4 fields of which include an autonumber, 2 text fields and 1 memo
field that are all filled in after opening this form. The person uses the
main form to select the account the data will be entered for.

What is the best way to be able to see the main form fields but have a data
entry subform where no previous memo's entered appear?

I have put data entry yes for the subform but no help!
 
More info - The subform fields are from a different table than the main form
fields if that helps!
 
Your sub is linked to the main yesno?

If you set the sub to go to a new record on opening and turn off the
navigation buttons the user should only be able to enter in new info.
 
I placed the following in the open event for the subform DoCmd.GoToRecord , ,
acNewRec Is this correct?

Yes, the form and subform are linked.

What do you mean by turn off the navigation buttons the user should only be
able to enter in new info? Navigation buttons?
 
Nick, I did turn off navigation for the subform and place d the open event
but of course after scrolling through the list in the above form area it came
across data in the field I wanted to be blank and new.

I may have to user a button to reset the subform as it may be a new record
when it opens but once I edit and find the account I want to enter on which
is not first in the list when the form opens I probably miss the new record.

Does this make sense?
 
Back
Top