populate form field based on one record in table - ???

[wendyd]

I've got a table which has one record. I need to fill a form text box with the value of one field in the record. I won't know the id of the record since that might change so I don't have anything to search on.

Help please!?!

Thanks!

 

[Dustman]

Try setting the rowsource of the text box to a SQL statement like this.

"SELECT " & strColumn & " FROM tablename WHERE "& strColumn & " = '" & strCriteria & "';"

I can't tell for sure what you are wanting to do but this will let you select which column to search through and what to search for. If this ins't what your needing.. give me a little more info about what you are doing. How is the id going to chang, etc. -Dustin
Rom 8:28

 

[wendyd]

Dustin,

Thanks for your suggestion. What I'm doing is inserting a name into a field on a form. The name comes from a table which has one record.

This database is being distributed to 300 sales people. They will personalize their copy of the database by entering their info. They have different employee numbers (which will be the ID).

Maybe I could use a wildcard to search the field?

Thanks!

 

[Dustman]

Okay, let me see if I get this.. are you trying to search through all the columns for that particular ID number? I'm still not really seeing it all. I'm not extremely skilled in SQL, you can check out

http://www.sqlcourse.com

and get the basics of what I know. I'll try to help you though if I can ever understand what you need . -Dustin
Rom 8:28

 

[wendyd]

Justin,

I could search through all columns for that particular ID and retrieve the data I need.

Thanks!