how to use a text box to enter numbers on a form which alse has a.

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

Guest

Hi
I have a form that has a combo box that pulls information from a table. In
addition to this I want to add an extra Text box on the form that is not a
field in the earlier table. When I enter a number in this text box I should
be able to save that number and the other data to a new Table. Any help will
be greatly appreciated.

Thanks
 
If I understand the question, make a query that includes both tables, then
use the query as the form's record source. Bind the text box to the
applicable field. When you say the combo box "pulls information from a
table", do you mean that you use the combo box to select a record based on
what you select? My answer assumes this to be the case. What "other data"
do you want to include?
 
Hello BruceM
Thank you for your earlier suggestion. but I guess I need little more then I
thought I would need. I have a Table called Academic Recods Job which has all
the jobs that I want to run( fields include Job Name, Job Title and so
on...). I would like to retrieve a record using a combo box able on the form.
But I would also like to I assign a job number to each job and more than one
job can have the same Job number. Also, I would like the form to let me edit
the records and save it to a different Table. So far I was able to create the
record source Table and the form with all the fields but finding it hard to
save it to the new table with the Job number( which is not part of the
Academic Records Table). Any help is appreciated.

Thanks
 
Back
Top