saving a record for a continuous form

G

Guest

I am writing a subroutine that uses a subform's recordset to open another
form. If there are no previous records, the code returns an error that there
is nothing in the recordset. How can I force the subform to save its data?
 
S

Steve

Like a any form, a subform saves a record in one of three ways --
1. When the user goes to a different or new record
2. When the form is closed
3. VBA code to explicitly save the record

PC Datasheet
Providing Customers A Resource For Help With Access, Excel And Word
Applications
(e-mail address removed)
 

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

Access Main form/Subform Navigation 0
Bookmark on Continuous Form 2
Select multiple records in the datasheet part of split form. 0
use recordset as source for form 16
Dynamically changing a subform's recordset using txt box 1
recordset for a subform 14
get sum from subform on button(on main for)click 3
unbound form returns values to table 2

Top