Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Getting data from a query to be a default value in a form

Status
Not open for further replies.

cppiston

Programmer
Feb 27, 2002
23
US
Hello all, I am having difficulty getting data to beome a default value in a form. My Access database is as follows. I have one form, in which the control sorce is a table to store information in all the fields. I have three combo boxes that a query uses to get default data for the above mentioned form. See, the control source for the fields where I need the default data cannot change. How can I get that data from the query to be the default data in the fields, to intern be saved on the table. Also, the fields cannot be locked withe that default data, just incase the default data may change a litle periodically. Do I need an expression, if so, how? I don't know much about expressions. Also, should the query make a temp Table? Thanks in advance.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top