Adding records.

  • Thread starter Thread starter Nathan
  • Start date Start date
N

Nathan

I am having a problem when adding records on my database.
I have a form with a list of text boxes to enter the data
in, and also a button which opens up another form with a
list of fields followed by checkboxes. On my form I have
three buttons; Add record, Delete Record, Confirm. The
confirm button simply refreshes the forms data so to add a
record you click add record, enter the data then click
confirm.
The problem I am having however is that when I follow this
procedure, the check boxes which I tick for each record on
the separate form are not saved. When I go back to view
the records all the options are un ticked.

I also have some navigation buttons on the form; first
record, next record, etc. Instead of following the
procedure above, if I click the 'Next Record' button it
allows me to add a new record and it also saves the data I
enter in the check boxes.
Although you may say just to use the navigation buttons to
enter the data, it is unsuitable for other users to do
this as it can be confusing for them. There for I need to
do it the other way.

Any help as to why this is happening and how to correct it
will be greatly appreciated.

Thank you
 
I would check 3 things

1) The check boxes are bound to the expected fields
2) The fields they are bound to are updatable un the forms underlying table
/ query
3) The code behind the Confirm button that does the save. (To eliminate, hit
CTRL+S)
 
Back
Top