Confused about when exactly record is created in back end table

[holden_1]

Hi,

At what point is a back end table updated with a new record created on a form in your front end?

I need to run a report of data i have just entered into a form and it returns black as the record doesn't yet exist in the table... is there a docmd to create the record?

thanks for any help.

Rob

 

[MStef]

In which moment do you run a report, and how ???

 

[holden_1]

OK, i figured it out myself... basically a record is saved once you move onto another. As i was attampting to run a report based on a query using data from the record i just entered on the same form, the query returned null as the record had not yet been created. if that makes sense...

solved using RunCommand acCmdSaveRecord inserted in the code before sendobject...

 

[MStef]

Ok, you can do 2 things:
1) Put the code:
Docmd.RunCommand acCmdSaveRecord
before you run the report.

2) Replace your command button on form futter.