HELP! need to populate field in Access

[Macinslaw]

Here's the deal, I do not know VB, VBA, or any other microshaft programming language. We have an access front end to a MsSQL database. There are 2 user input fields on a particular form that polls our database and checks for matches against the users input of productid and shipto address id. There is some VBA code on the backside.

Originally, the cade would not allow for any existing product or shipto to be input, I was able to change it so that is will allow it as long as there is not an already existing combination on the same row of data.

Problem:

I have a combo field in the the access for that has a SQL query in it. When the productid and shiptoid are input, it runs the query, however, it does NOT populate the field with the single outcome. There can only be 2 responses, null or a value. The match IS returned, and when you click on the drop down arrow, you can see it is there, but it will not remove the null and display the match on it own in the field.

I need help, I've been working on this for 3 days, driving me crazy!

Thanks in advance.

 

[PHV]

I need help
On WHICH code ?

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Macinslaw]

Sorry, guess that would have been a help, huh?

I have a check in the VBA that looks for a null or a value of PH_Prod. This is the name of the combo field that runs the SQL Query. I need some way to make the results become the only value of PH_prod, so, whether it's in the VBA or the access form gui, I really don't care, I just need this to work. Thanks.