ShanesLittleT
New member
- Local time
- Today, 15:24
- Joined
- Sep 18, 2003
- Messages
- 6
Access 2000
I'm using an unbound main form to navigate orders. I have several combo boxes and command buttons I'm using to change a subforms recordsource to display orders. One in particular is giving me a lot of problems. I have an unbound text box on the main form named txtFind. I'm allowing the user to type all or part of a customer name and then using a command button (cmdFind) to try and match the customer name in the subform and display all records that match. The subform is a continueous form and the field I'm trying to match on it is txtCustomers. I have CustomersID field on the subform and coverted it to a combo box. In the second column of the combo box I put Customers: [LastName] & ", " & [FirstName] then placed a unbound text box (txtCustomers) on the subform and have it's control source =CustomersID.Column(1). When I try to use the cmdFind to try and find records (matching what's typed in txtFind on main form to txtCustomers on subform) I'm having no luck. This is working for a number of other combinations that I'm using for other situations but not on this particular one. I posted a couple of days ago and tried all suggestions as well as hours of other combinations of code and I'm flat striking out. Any help would be greatly appreciated.
Thanks a head of time,
Shane
I'm using an unbound main form to navigate orders. I have several combo boxes and command buttons I'm using to change a subforms recordsource to display orders. One in particular is giving me a lot of problems. I have an unbound text box on the main form named txtFind. I'm allowing the user to type all or part of a customer name and then using a command button (cmdFind) to try and match the customer name in the subform and display all records that match. The subform is a continueous form and the field I'm trying to match on it is txtCustomers. I have CustomersID field on the subform and coverted it to a combo box. In the second column of the combo box I put Customers: [LastName] & ", " & [FirstName] then placed a unbound text box (txtCustomers) on the subform and have it's control source =CustomersID.Column(1). When I try to use the cmdFind to try and find records (matching what's typed in txtFind on main form to txtCustomers on subform) I'm having no luck. This is working for a number of other combinations that I'm using for other situations but not on this particular one. I posted a couple of days ago and tried all suggestions as well as hours of other combinations of code and I'm flat striking out. Any help would be greatly appreciated.
Thanks a head of time,
Shane
