Goto new record (1 Viewer)

Gismo

Registered User.
Local time
Today, 15:45
Joined
Jun 12, 2017
Messages
1,298
Hi all, need some I have advise please, I have 2 subforms, link with parent / child. top data sheets displays related record in bottom single form. update works perfect. problem is I need to click a button to goto new record. error is you cant goto specified record. if I go to the query it shows new line and not at the end of a record set so that scenario is out. what else could I look for?
 

Ranman256

Well-known member
Local time
Today, 08:45
Joined
Apr 9, 2015
Messages
4,337
the subform should show an empty row (the ready new record )
the record selectors should show a * tool to add new records
and if you cannot add new records by typing in the fields, then the subform may be setup wrong.

the subform should link to parent to allow records.

the query for the subform cannot be many tables, it should be only 1 table to add child recs.
any extra tables can prevent entry.
 

Gismo

Registered User.
Local time
Today, 15:45
Joined
Jun 12, 2017
Messages
1,298
The subform is from only one table and it also shows the * for new record. I can add a new record when using record selector on new record. Don't think I have a problem with the setup. It just does not go to a new record when button is clicked. not sure what else to look at
 

Users who are viewing this thread

Top Bottom