D
Dmac
Hello,
I have a combo box (cboPNumber) on my form that queries a tblLookUp for a
PNumber field. The number is inserted into PNumber field in tblMaster.
That all works fine. I have two other fields on the form that are txtName
and txtUnit.
What I am trying to do is insert the corresponding txtName and txtUnit data
into the respective fields on the form as well insert the data into the
fields in the tblMaster table when the PNumber combo box is updated.
I have tried using combo boxes for the for the txtName and txtUnit fields
and doing a Me.txtName.Requery on the PNumber Update Event. That does work,
however, the information isn't visible until you select it from the menu.
The same with the txtUnit combo box.
I have also tried using a List Box, but since the form is a continuous form,
the information is shown in all the rows of the form.
Any help would be appreciated.
I have a combo box (cboPNumber) on my form that queries a tblLookUp for a
PNumber field. The number is inserted into PNumber field in tblMaster.
That all works fine. I have two other fields on the form that are txtName
and txtUnit.
What I am trying to do is insert the corresponding txtName and txtUnit data
into the respective fields on the form as well insert the data into the
fields in the tblMaster table when the PNumber combo box is updated.
I have tried using combo boxes for the for the txtName and txtUnit fields
and doing a Me.txtName.Requery on the PNumber Update Event. That does work,
however, the information isn't visible until you select it from the menu.
The same with the txtUnit combo box.
I have also tried using a List Box, but since the form is a continuous form,
the information is shown in all the rows of the form.
Any help would be appreciated.