Autofill form problem

  • Thread starter Thread starter CarrolM
  • Start date Start date
C

CarrolM

I have created a form in a database that needs to have
one field be autofilled from a table of information.

I have a query created from the master file of insurance
claims that are to be filed into boxes. A form is
created from this query.

When a box number is entered into the form, the label
barcode number autofills from the "Box/Label" table.
The problem occurs when label is deleted in the
query...the number is also deleted from the "Box/Label"
table. This in turn deletes the label number from the
entire query information that has been entered. When the
number is replaced in the table, the information is
repopulated into the data again. This is becoming a
little frightening because of the enormity of the
database.
Hope you can help, Thanks
 
Without more details such as some code snippets it's hard
to pinpoint the problem. But offhand, I'd say that you
have bound forms which is convenient but troublesome at
times. If you were not have bound forms you could then
have more control over events. It will mean more coding
though.
Geof.
 
Back
Top