New Record in Form

G

Guest

I would like a new record to appear when entering in a subform. The Main
form Data Entry Property is set to no, because I need to see all the items in
the table, but the subform I would like to have only a new record show. When
I set the subform Data entry property to yes, it doesn't correct it.
 
G

Guest

Hi,

You can do this by setting a filter value for the subform e.g. id<-1 whereby
-1 is not a value in your database of course.
 

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

Print Report/Subreport single Record 0
New Parent Record from Navigation Buttons 2
Macro doesn't work first time form is opened. 2
Using form and subform not connecting to two separate tables 0
First Subform record gets modified when closing form 3
Unremovable horizontal scroll bar on subform 1
Trouble associating parent form record to subform's record 1
VBA Syntax for subform record source change 6

Top