Getting a Combobox on a subform to update

[marcfl]

Hi,

I have an Order form on which you select a client and the clients details (address, etc...) are brought up. On the same form is a Subform where order details are placed. a product is selected from the combo box (which works) and some text boxes are supposed to be updated with the details that are stored in the relevant table. The record source for the subform i created is a query which contains the 6 fields i need.

When i try to use this subform though there is no dropdown list but the combobox is there.. when i try to use the wizard to create a new combo box i get told that there are no valid fields and that i need to select a new source.

Frankly i havent got much experience in dealing with databases and VBA so im not sure where the problem is.. ive attached my DB incase i havent provided enough details.

Cheers

 

[boblarson]

I get this error message when trying to download your file:

HTTP1.1 STATUS 403 Remote Access to this object forbidden This file cannot be directly accessed from a remote site, but must be linked through the Brinkster Member's site.


Bob Larson
A2K,A2K3,A2K7,SQL Server 2000/2005,Crystal Reports 10/XI,VB6, WinXP, and Vista
Free Quick Tutorials and Samples:

http://www.btabdevelopment.com

 

[marcfl]

Dont worry about it i managed to fix it myself after a few hours of frustration Thanks for the effort tho, its much appreciated.

 

[ProgramError]

I got the file was in a corrupt state or unknown format. mmmm!!!!

Ian Mayor (UK)
Program Error
Always make your words sweet and nice. Because you never know when you may have to eat them.