code query to update textbox and table

P

PRAV

hi, how to run a query in my form_load (ms access 97) so it set the
value of the query to a textbox (txtinfo) and put the value in my
tblInfo table. My query is Select count(project) from tblproject;
 
G

Guest

Instead of Select Count, you could use DCount("project","tblProject") as the
default value for the textbox.

Is the txtInfo textbox bound to a field in the tblInfo table? If so, it will
automatically save the value.

Barry
 
P

PRAV

But how can i get the data from a listbox (lstPercent) to display in a
textbox (txtPercent) on the same from. I will hide the listbox.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Update query not working 2
Access #Error & Excel Pivot 0
How to Populate Data from a table to another 0
Autofill inside if/then statement 2
Return Query result to textbox 12
Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Update query using Count 4

Top