In post 2, I already explained combobox should be UNBOUND because you have only one table. If you bind it to field then you change data in record.
Controls used to enter filter criteria to search for existing record should be UNBOUND.
In post 2, I already explained combobox should be UNBOUND because you have only one table. If you bind it to field then you change data in record.
Controls used to enter filter criteria to search for existing record should be UNBOUND.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Mike -- sticking w/ current solution... it'll be ok. If change is needed, I'll repost question in the near future.