Start Subform on a blank record

S

Scott

I have a subform that is setup to be data entry only; however, when i view it
in subform mode, it displays previous records. I don't care if it displays
other records, but how can I make the first viewable record the new record?

Any help would be greatly appreciated.
 
K

KARL DEWEY

Change the Data Entry property to Yes. You will not be able to view other
records.
 
S

Scott

I have already done this. it works ok for the first record on the main form,
but once i go to another record it brings everything up. also if i bring the
form up by itself and not as the subform, it is entry only... Any other
suggestions?
 
K

KARL DEWEY

This I did not try and might not work. Create an event or call a macro to
Requery when you double click the subform. You will need s space where you
can click.
 
S

Scott

This did not work... Does anyone else have any other suggestions? I saw
some other posts where it had about entering in code, but I've never done
that before, and a little scared to do that without detailed instructions.
Thanks in advance...
 
E

ernie

I find that clicking the >* button on the Main form puts the subform into
Data entry mode too. This may just be the way the tables are linked which in
your case is unknown.
Best of luck,
ern.
 
Top