Code to read from a form.

JustMaybe

Registered User.
Local time
Today, 13:28
Joined
Oct 18, 2002
Messages
134
Hope this isn't too simple a question..

....from a java programmer trying to code VB for the first time!

Here's the background

I've got a form called 'orders' in which a user types in the order details (e.g. customer name, delivery address etc.) the actual products ordered are detailed in a subform on this form. this subform stores the 'detail ID' and products ordered in a table 'order_details'.

The problem is i want the users to have an easier way to search add a product through the list, rather than the current drop down list (fine for test data..but for the actual number of products it will be insufficent). So i have created a button on this form...'add a product to order'

The idea is that the user can search for the product by category, scroll untill the desired product is found, then simply press another button 'ADD' and this product will be added to the subform in the order form (and the actual record will be in table order-details)

The problem is i can get the information to be moved between two tables. BUT the product_add form (linked by the 'add a product to order' button) is made from information in the 'products table'

#What this all comes down to....is how do i vary code to take information from a form rather than a recordset table??????

thanks for reading this...and for any help!!!!!

S
 

Users who are viewing this thread

Back
Top Bottom