ProdId(AutoNum,PK),
ManId(Number,FK)
ManPartNo(Text)
ProdDesc(Text)
The manufacturer(ManId) is a Combobox where you pick the manuacturer to assign to a product, but some times you have to add a Manufacturer that is no in the list, so DoubleClick the ManId Field the AddManForm opens and you can Add new Manufacturer data.
In the AddManForm Close event I wrote some code to requery the [ManId] ComboBox inside the SubFormRawProducts, but Im confusing about how is the right way to point to the [ManId]Field in the sub form.
I have the following code but nothing happens, no error showed up but also the ManId Field doesn't refresh
Expand|Select|Wrap|Line Numbers
- Private Sub Form_Close()
- If (IsLoaded("SubformRawProducts")) Then
- Forms!BusquedaProd!SubformRawProducts!ManId.Requery
- End If
- End Sub
Thanks
Raymundo Walle