Drop Down Box Help

[mattc66 via AccessMonster.com]

Hi All,

I have a drop down box on form. I have it setup to look up data from a part
number table will call it tblData to add the data to a different table called
tblDoc. However if the item is already in the tblDoc I'd like it to bring up
that information rather then over writting the tblDoc. What would the code
look like?

 

[Jeff Boyce]

I can't tell from your description if your tblDoc uses a "lookup" data type
for that part number, or is a data type compatible with the primary key
field in tblData.

The combobox in your form gives a list of available choices. If the
combobox control is "bound" to the underlying correct field in the table
(tblDoc), it should display the already-chosen value.

Are you saying that you don't want anyone to change their choice, once it's
been made? If so, how do you handle mistakes?

Regards

Jeff Boyce
Microsoft Office/Access MVP