Cant save record!

  • Thread starter Thread starter Steve
  • Start date Start date
S

Steve

Hi,

This seems a really simple thing to do, it just doesnt
seem to work.

I have a form, bound to a table. The user can input new
records into the table via the form.

However! The user inputs the details, then clicks on the
exit button. The record doesnt save!

I have added a 'standard' Save record button, using the
wizard and this doesnt work either!

How do I get the record to save?

I said it seemed simple.....:)

Cheers, Steve.
 
Jeff,

The Allow additions property is set to Yes.

To save the record, I need to press TAB at the end of the
record being input.

I have tried different things now;
Moving to next record, then back again.
Using sendkeys("{TAB}")
Docmd.Save

It just doesnt want to know :/

Steve
 
The forms recordset is involved in a relationship between
2 tables.

Can this affect things?

Steve.
 
Does the status bar at the bottom mention "this recordset is not updatable"?

The query you use to fill the form may not allow updates. What happens if
you run the query and try to update something directly in the query output?
 
I have actually sorted it now.

There was a join on the first form between the 2 related
tables.

Obviously when I create a new record, there is no related
record in the second table.

I have amended the form to add a new record to the second
table before saving the record in the first table.

whoah!

Cheers for the help,
Steve.
 
Back
Top