Error "No Current Record" on save

[jackie77]

Hi all

I have been working on a bound form (For ages!) that I can't seem to getting working

It records deliveries and what I am trying to achieve is after the form has been filled in the user will click a save button where the record will be added to the table and a record automatically printed via a report and emailed to the shop manager, but i keep getting the error "No Current record" no matter what way I try to do it, I have tried using to run the report. Is the best way for me to accomplish this o change it to an unbound for and run an insert query on click?

any suggestions would be great i have attached a copy of what I have been working on

Cheers
Jackie :banghead:

View attachment DatabaseDelivery.accdb

 

[JHB]

Yeah, there are some major error in it.

1. You use a boolean with the name bSaveClicked to determine if the save button has been clicked, but you never set it (to true) in the save button click event.
2. In the DoCmd.OpenReport is there two errors
3. In the DoCmd.SendObject is there one error

I've attached the database.

 

[jackie77]

Hi

Thanks JHB for having a look at it for me, I'm flying now your help was most appricated cheers

Jackie