Search results

Thanks Paul, Got this to work but it only adds the 1 field that I selected from in the combi box into the tblOrder Details although I have added the fields I require when designing the Combi box. Alf

Hi, wish to design an invoice package but have problems on setting up a Master Form and subforms . Tables created Customer Stock Order No. Order Details I wish to open an invoice form and do the following:- 1 - Select the customer via a Combi and display details (no problem) Master form...

Thats OK but how do I link the record selected in the Combi Box to the subForm Order_details

HI, Have set up form as you suggested but can't seem to get the stock item selected by the combi box to then fill a new record in the Order details subForm/table. Think I will need some VBa code?

Thanks for your reply. I understand what you are saying but will just confirm what you are suggesting. I make a Form with the main Table Orders. I then have a subform for Order Details. The problem is to start with I need to lookup (using a combi box) the customer tel no. to get the...

Hi, Am trying to write a simple invoicing program where the tables are Customers Stock Order No Order Details I wish to make an Invoice input form by first picking the individual customer (no problem wit a combi box) and then being able to search the stock with a combi box showing record in...