prevent a form from creating a new entry in the source table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a form that automatically displays client data based in a client ID
combo box. When I look up a different client and then try to close the form
it tells me that it cannot record the new information because it will create
duplicate primary keys. How can I turn off the write feature on the form so
that it will not try to add entries to my table?
 
jswatson2 said:
I have a form that automatically displays client data based in a client ID
combo box. When I look up a different client and then try to close the form
it tells me that it cannot record the new information because it will create
duplicate primary keys. How can I turn off the write feature on the form so
that it will not try to add entries to my table?
Click to expand...

If your intent for the ComboBox was for it to navigate your form to a specific
record, make sure it is unbound (no ControlSource). Otherwise you are altering
the current record rather than navigating to a different one.
 
Back
Top