Form data from query to table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Text Box A on my form is populated by a query. I would like to enter data
into text Box B and that data be stored in the record that matches Text Box A
in the table C. I know this is easy, but... I'm sitting here staring
blankly and not coming up with the solution. Thanks for the help!
 
Mark,

I don't think anyone can answer this without knowing more details of the
tables involved, and the relationships between them. Assuming TableC is
included in the query, and assuming the query is updateable, and
assuming TextboxB is bound to the required field, then entering the data
into TextboxB will put it in the table. But the fact that you have
asked the question makes me think that one of my assumptions is not
correct. Maybe you could post back with the SQL view of the query that
the form is based on, and let us know which fields in the tables you are
talking about.
 
I'll give it to you as an example, because it might be too wordy otherwise.
I have table A, query B, Form C and Form D. Table A is a master table with
one field that needs to be populated by the user... we'll call it field E.
Query B is a very simple "Select fields F, G... from table A where F = '1' ".
Form C has two combo boxes that are populated by fields F and G from query
B. The user will choose the appropriate record from the combo boxes and will
click a button that will take them to the data entry form, D . At the top of
D, will be the employee the user chose on Form C as well as a text box. The
user will be able to enter data in this text box and that data will populate
field E in table A in the employee record that was chosen.

Right now, when I enter something in my text box, it populates the first
record in the table even though the 50th employee is the one displayed at the
top of the form.
 
Mark,

What is the procedure by which you are opening Form D? What is the
Record Source of Form D? How does " the employee the user chose on Form
C" got onto the "top of D"?
 
You must log in or register to reply here.

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

Append query and combo box on the form 1
Filling a text box on a form with VBA code 4
Using Collect Data with Related Tables 3
How to display a list box with select items in edit mode 1
Unbound text box repeats for every row on a continuous form. 3
Set up query, form to "View / Edit Data", vice just display data? 3
Displaying query result on the same form as selection fields 6
sending data from my text box to my table 5

Back
Top