Printing related information

[eludog]

I am trying to put together a form that will be able to print out various information in different text boxes. I have the text boxes set up, but want to be able to type in the emplyee ID number in the first text box, and have the rest of the text boxes print out the related information. Right now, I have the first text box being a combo box with the list of employee ID's showing up, but when I choose one, the other text boxes don't change. Please help! Do I need to code, or is there a simple answer for this problem.

Thenks,Egan

 

[HarmonyGirl]

It sounds like you might want to use a report vs. printing the form itself. It also sounds like what you want is to select a value in a combo box, and based on that value, have other fields automatically populate.

I've successfully used 2 methods to do this. One method is described by Jack Cowley in an earlier post, titled "Selecting multiple fields from a combo box". Jack describes where to add this code like this to the After Update event of the combo box:

Me![Field1] = Me![ComboBoxName].Column(0)
Me![Field2] = Me![ComboBoxName].Column(1)
Me![Field3] = Me![ComboBoxName].Column(2)

However, sometimes I've had trouble with this method. What has always worked for me is to use a query that returns those other values that I want to autopopulate, and use that query as the source for the combo box.

HTH,
HarmonyGirl


[This message has been edited by HarmonyGirl (edited 04-04-2001).]