Data to appear dependant on first data entry field

[Paul_birm]

hi hope you can help with this folks...

i have a form which opens a subform.

on the 1st form, the user puts in a Part Number

when the subform opens, the PartNumber is prepopulated
but a field next to the part number needs to go away and look at a list of BOM items and populate the child parts for the number of Child Parts on the BOM this is NOT doing this and i just dont know were to start with the VBA coding.

Help Please !!!

 

[Guus2005]

the field next to the partnumber is probably not bound to any field. The rest of the subform is bound.

perhaps the field next to the partnumber is filled using the onopen or onload event.
use the onCurrent event to repopulate it.

Share & Enjoy!

 

[Paul_birm]

the field is bound... here is the text that is in the field

=[tbl_TempQuote]![spart]

show this SHOULD be the part number (spart) from the data table (tbl_TempQuote)

or am i missing something ??

 

[Guus2005]

could you post a sample database describing the problem?