Create a simple data entry form to update project status

[Guest]

I am having problems with creating a form used to update a table. I created
a form that uses a query to combine information from two different tables
(one is for project status, the other is for project information they are
linked by the project number). I want to be able to enter a project number
in to a text feild and update the rest of the feilds in the form to show me
the current status of the project. I have combo boxes to let me update the
different fields on the form for the projects current status(which works). I
can use the record buttons to go one project at a time, however when I type
in a project number in the text box [txtProject_Number] it updates the
current project number field in the table. I have tried to use my textbox as
the criteria for my query, but it doesn't work. The testbox is bound to the
query.

 

[Jeff L]

The combobox wizard should be able to assist you with this. Create a
combobox for your Project Number. Choose the third option (Find a
record based on value selected). Click Next, Select Project Number from
the list of available fields, next, next, Finish.

 

[Guest]

Jeff,

Thank you for the help. Should there be and update query code writen into
the combobox? I've tried this several ways, bound and unbound, and I'm still
having trouble getting it to work right. If I include a line of code to
update the query it get the standard invalid parameter error when I open the
query or make a change to the form.

Travis

 

[Guest]

Jeff,

I would like to retract my posting from 6/5. I finaly figured out my
problem. When I used the actual table and not the query it works like I want
it to. Thanks again for your help.

Travis