Restricting a selection, unless a new record is used. (1 Viewer)

[tacieslik]

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.

 

[Pat Hartman]

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?

 

[tacieslik]

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?