Run a query from VB, to update a textbox

[psiborg]

Here's the situation...

On the Form, I've got a ComboBox (ProjectNumber), a TextBox(DateWorked), and another TextBox (Hours).

What I'm trying to do is to fill in the Hours, based on a query (already built) that will pull up hours that were worked on DateWorked, and only on a certain ProjectNumber.

Is there an easy way to accomplish this, without extensive knowledge of VB or Access? I can get around in both, well enough, but most of what I know has come from Help files.

Any help would by greatly appreciated...

 

[robertsfd]

Check out the following:

thread702-536280

I think you're asking the same thing.

 

[psiborg]

Not quite the same thing.

Basically, I'm attempting to input time spent on several projects into a table. On a different table, I already have the time for one set of projects called out (on individual jobs), for each day. Essentially, it's a project where time is spent on several tasks, each of which is tracked for accounting purposes. The time spent on other projects are added manually on the input form, but this one project is being taken care of on an individual basis.

What I need to do is to run a query that will pull out the hours worked on this particular date, total them, and populate the Hours field, just for this date and project.

I had looked at your thread, previously, because it had seemed to be close to what I was looking for. Unfortunately, it's not quite the same problem...just awfully close. You know what they say..."Close only counts in horseshoes, hand-grenades, and little atom bombs".