combo box to update the other fields

[jknight]

I wish I could but it has personal information/data related to the purpose of the database and I don't think I should be posting that. I can provide any table names, form names or any code I have used. Sorry. Can you still help?

[pbaldy]

I just can't figure why it would have a compile error on "Me", which is commonly used. I assume the data type of the field is numeric? You can try the full form reference instead of the "Me" shortcut, but I don't have high hopes for its success. What exactly is your code now?

[jknight]

Oh maybe data type of the field is an issue, the data type for "RequestID" is AutoNumber does that matter?

Here is an overview of what is happening.
The Form A (Search Requests) has a textbox that searches and table and displays results in listbox with RequestId (Unique to each request) being the first column displayed.

On double clicking the user should be able to see Form B (Details View) of the requests. I followed the tutorial you had provided but when I doubleclick it takes to blank form (of Details Views) but it should be showing the information based on the "RequestID".

[pbaldy]

No, autonumber is a numeric type (Long Integer). You said the ID is the "first column displayed". Is it actually the first column in the row source? Your code expects it to be. Is the record source of form B the entire table? Do you know how to set a breakpoint and see if the listbox is returning what you expect?

http://www.baldyweb.com/Debugging.htm

See why I asked for a sample? There are a lot of things to check.