I have a Main form with a Sub form. On the Main form, there is a combo box that allows the user to select a Supplier. The user then fill's in the info for that supplier in the subform.
I want the Supplier combo to only let the user select from it once unless a new Subform record is created.
Any Ideas, I've posted this question before, but had no luck.

You should have continued the first thread so people could see what was previously suggested. I already answered this question. If my suggestion did not work, what was wrong with it?

I Did Pat, but I had no reply from you! (see the following):

tacieslik
Junior Member posted 06-12-2001 05:27 AM
--------------------------------------------------------------------------------
Thanks Pat,
I know what was wrong, I needed another End If statement.
Unfortunatley, it does not work for some reason?
I'm able to choose a supplier, choose parts and then choose different suppliers on the same form?
Since I added the code you gave, the text box that is filled when a part number is selected does not display the result unless I do a refresh. Do I need a requery?