Display on Form Only

[drStealth]

Hello all, I am working with an Access Project. I have an Access Form which is interacting with a SQL table. I want the user to select a value from a combo box, and then have the related data populate other fields on the form.

This is frustrating because I got this to work in Access 97 using "select distinctrow" as the row source, and working with the columns options in the form. However I cannot get it to work with Access project.

Any and all thoughts would be appreciated. Thanks. drStealth

 

[jplum]

I am assuming that the fields are unbound.

You would have to write some code to do this. The code would have to go to the table(s) where the other data is stored, find the record that matches the users selection in the drop down box and then populate the other fields with it.

Are all the other fields in the same table or are there multiple tables?

Jennifer

 

[drStealth]

Jennifer, thanks for your input. The fields are currently in multiple tables but I do have a stored procedure that can be used where all the necessary fields are together. If code needs to be written (I assume VB), then can you or someone suggest a good book as a reference. I don't know VB and have no VB resources available here at work.

Any other thoughts would be welcomed. Thanks. drStealth