By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
426,107 Members | 1,323 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 426,107 IT Pros & Developers. It's quick & easy.

Can this interface be realized? How?

P: 1
Hi,

I have a question which i have thought and tried for a week. But still not sure if I am on the right way to do it.
The question is I need to set up an interface to select multiple productIDs, which are from a table. Once people selected 1 productID, the corresponding Description and Quantity fields are displayed. Then people go further to select other productIDs. The corresponding fields are displayed for each productID. Is it a possible way to put the productID in a combo box, display the corresponding other fields in text box; and automatically (or manually? I need select 20 productIDs at least ) produce 1 row including 1 combo box and 2 text boxes for each selection of productID.

currently i used the subform/subreport to contain the productID (combo box) and Description (text box), Quantity (text box) . The subform is filled with one same initial record for all rows. When I change either row of selection of productID the all other displayed rows changed to the newly one.

Is it possible to realize it under subform/subreport? Is it a good way for the interface?
Any suggestions are appreciated!

Fy
Jan 14 '08 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 374
Can you include some of your table structure to be able to give you a more detailed desription as to how to proceed.

It's going to depend on how you've setup the relationship between the main and the subform and how much VBA coding you've done.

Thanks,

Joe P.
Jan 15 '08 #2

Post your reply

Sign in to post your reply or Sign up for a free account.