CallumMascall
New member
- Local time
- Today, 04:29
- Joined
- Sep 18, 2020
- Messages
- 15
Hi all,
To give context, i am using microsoft's goods database, but modifying it slightly to my needs.
On the Purchase Order form, there is a combo box to select a supplier
I am going to be passing the details from this form over to a report to send off as an order form
In order to do this, i need to get the suppliers details from the supplier table. So i went into the Row source of this combo box and added the "address, city, province, Postal Code etc." that i need. I wanted to then use vba to do "me.txtSupAdd.value = me.cboSupplierID.column(2)" and so on for each of the combo box items to put those values in a text box in order to pass them over to the form easily, i was going to just set the visibility to false.
attached is two screenshot from debugging this issue.
It adds the address in just fine, but any following items just show the value as "NULL"
I cannot get my head around why it is getting one of the fields from the record but all the rest are returning as NULL
if anyone has any suggestions or more effective ways to achieve what i am trying to do, it would be much appreciated
Thanks
To give context, i am using microsoft's goods database, but modifying it slightly to my needs.
On the Purchase Order form, there is a combo box to select a supplier
I am going to be passing the details from this form over to a report to send off as an order form
In order to do this, i need to get the suppliers details from the supplier table. So i went into the Row source of this combo box and added the "address, city, province, Postal Code etc." that i need. I wanted to then use vba to do "me.txtSupAdd.value = me.cboSupplierID.column(2)" and so on for each of the combo box items to put those values in a text box in order to pass them over to the form easily, i was going to just set the visibility to false.
attached is two screenshot from debugging this issue.
It adds the address in just fine, but any following items just show the value as "NULL"
I cannot get my head around why it is getting one of the fields from the record but all the rest are returning as NULL
if anyone has any suggestions or more effective ways to achieve what i am trying to do, it would be much appreciated
Thanks