Putting data from server into combobox

[jpl458]

Have data entry form that uses text boxes for all data fields except one, City, which uses a combo box that is linked to a city table that has all the city names in a 25 mile radius. Makes data entry easier. Problem is I have a need to populate those text boxes with the data from the server, but I can't load "City" from server into "City" on data entry form - the combo box. Here is the line of code that won't work:

Me.City = rsdbo.Fields("City"}

All the other fields work fine. It's the combo box that's the problem

Is there a way doing this, or a cool work-around?

Thanks in advance

jpl

 

[genomon]

Me.City = rsdbo.Fields("City"}

First, replace the closing curly bracket with a closing paren around the field name.

What to you mean by "the data from the server"? Are you opening a recordset on a linked/backend table?

Cogito eggo sum – I think, therefore I am a waffle.

 

[TheAceMan1]

How are ya jpl458 . . .

If Me.City is the combobox why do you need it if your populating the textbox portion of the combo from the recordset [blue]rsdbo?[/blue] ... no selection from the combo is being made!

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[jpl458]

It was the jerk writing the code that was the problem. I looked at the curley bracket it it looked regular to me. Time for an eye exam.

Yes, i am using linked tables, rsdbo is the recordset.
Thanks for taking the time, appreciate it. All ok now.

jpl

 

[jpl458]

Access is the front end for the data on SQL Server. As transactions take place (sales) only the account number is added to the master file via a bar code scanner from a card that is given to the customer. The customer fills out a sheet with their info and the data is added the server later, using the data entry form. I check first to see the account number on the server matches the one on the sheet. If there is a match I check to see if data has been filled out already (which is entirely possible in this environment.) I put the data from the server back on the data entry form so the person entering can see if its the same on both the sheet and the server. If not, save the sheet because the account number was written down wrong.

The environment is loose, so I have to check everything.

Long explanation for a simple operation.

Hope this makes sense

Thanks

jpl