Using a Combo Box 1

[JBuckley2000]

Hello,

I have a slight problem. First of all I have a data table which has all of my part numbers and their relative information (part description, quantity, unit of measure, how many per pallet, etc.). What I want to do is create a form in which a user can choose the part number, then the rest of the information automatically generates on the form from the original data table, so that we can print out moving tickets. I then want the information to be saved on another table so that I can keep track of all of the tickets that we print out each day, thus the production for a certain department can be calculated.

My main problem is not creating the form, but automatically bringing up the information and saving what I pull up in a new table. I am not good at using Autp Lookup. I try to save the info to a new table, but it never works.

Does any of this make sense? Please send another thread if I need to explain this more. Thanks, JSF

Jason Facey
jfacey@lithonia.com

 

[RBE]

Do you mind using more then one form?.. If you don't, my suggestion is to create a second form that has all the information you want to pull from the first table. Use a query for the second form that uses the ticket number entered on the first form as the critera. This will enable you to enter more then one ticket if you want, and will pull all the information into a form. Then use an append query in an on click control button to add that information to the second table. Short of using a combo box and dlookups I know of no other way to automatically bring back information into a form, and then the information is unchangable. I am no expert though so someone else may have a better solution.

 

[BillMc]

Have you tried using and action query to update the other fields. It works like this: After selecting the Item, upon exiting the field an action query can be activated that will fill in the blanks. I have used this method many times in my own applications and it really works well.

You will need to create a macro that will run the action query. This macro will be activated ON EXIT (found on the Event tab in Properties for Item field.


The sequence of your Macro is as follows:
Run Command: Refresh
Open Query: (Action Query Name)
Set Warnings: NO
Run Command: Run
Close: (Action Query Name)

Good Luck. Bill