2 Comboxes with same info on a form.

[KerryDee]

Hi I am hoping for some help please.

I have 2 Como boxes on a single form:

The 1st Com box is for Replacement, the 2nd Com box is for Correction. The user can choose either the Replacement or Correction combo box but not both.
My problem is that they are both using the same information Serial Number etch., when I choose Replacement box, the Correction Combo box Auto Fills. Is there a way to prevent so that I can choose either box without the other one Auto Filling?
I am attaching a sample copy of the database below.
Thank you very much in advance.

KerryDee

 

[Ranman256]

in the afterupdate event of a box,
set the other to null, cboBox = null

 

[KerryDee]

Hi thanks again for your help, but exactly where do I put the code. Sorry I am an Access Novice.

Thank you.

 

[bob fitz]

I think the problem here is that both combo boxes have the same control source.

 

[KerryDee]

You are right. Is there a way for when I choose one combo box for example Correction not to have the Replacement one show up and vice versa by using some type of code?

Thanks for your help and sorry for the late reply.

KerryDee

 

[bob fitz]

You are right. Is there a way for when I choose one combo box for example Correction not to have the Replacement one show up and vice versa by using some type of code?

I expect it would be possible, but why have two combo boxes in the first place?

 

[KerryDee]

Thanks for asking, but the information on the Access form I uploaded is for a form (which is built in a report in Access), that is required by a state agency. It allows a user to choose either a Correction or Replacement but not both.

Thanks,

KerryDee

 

[JHB]

Try the attachment, see if it full feed your requirement.

 

[KerryDee]

Thank you so much, it's exactly what I needed!!!!!!

Thank you. Thank you. Thank you!!!

 

[JHB]

You're welcome, good luck.