By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,932 Members | 1,454 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,932 IT Pros & Developers. It's quick & easy.

Form field update from table?

P: n/a
Ok so I am working on a database where one of the fields is a list of
employee names. I want to have a table called "employee names" that my
client can enter and delete employee names from. Then the main form
where the combo box field will be automatically updated to contain the
employee names that were entered.

I hope this makes sense. I looked here for help, but its hard to
narrow down exaclty the type of help I need. If anyone has a
suggesstion or a previous post that you can point me to.... the help
would be appreciated.

Thanks.

Sep 27 '06 #1
Share this Question
Share on Google+
4 Replies


P: n/a

bobchabot wrote:
Ok so I am working on a database where one of the fields is a list of
employee names. I want to have a table called "employee names" that my
client can enter and delete employee names from. Then the main form
where the combo box field will be automatically updated to contain the
employee names that were entered.

I hope this makes sense. I looked here for help, but its hard to
narrow down exaclty the type of help I need. If anyone has a
suggesstion or a previous post that you can point me to.... the help
would be appreciated.

Thanks.
You mean that instead of writing each individual name to its own record
in a child table, you put them all in one field and want to be able to
delete one here and another there?
Stop. Use Split to break the names out into individual records and
write them to a child table. Then this is simple.

Sep 27 '06 #2

P: n/a
You mean that instead of writing each individual name to its own record
in a child table, you put them all in one field and want to be able to
delete one here and another there?
Stop. Use Split to break the names out into individual records and
write them to a child table. Then this is simple.
no. what i mean is... i the list of employees will change from time to
time. so i want the user to be able to go to a employee name table and
edit the list of employee names. then in the form where they do the
data entry, there is a drop down field where the employee names appear.
i want that field to automatically update based on the employee name
table.

Sep 27 '06 #3

P: n/a
I see now. If you create a comboox on your form with the wizards
enabled, it'll walk you through most/all o this. Set the rowsource to
a query along the lines of

SELECT Employee.EmpID, Employee.FirstName & " " & Employee.LastName
FROM Employee
ORDER BY Employee First, EmployeeLName

and you should be good to go.

Sep 27 '06 #4

P: n/a
do a .Recalc on the form containing the combobox, or a .Requery on the
combobox itself if you want to refresh only that one.

bobchabot schreef:
>You mean that instead of writing each individual name to its own record
in a child table, you put them all in one field and want to be able to
delete one here and another there?
Stop. Use Split to break the names out into individual records and
write them to a child table. Then this is simple.

no. what i mean is... i the list of employees will change from time to
time. so i want the user to be able to go to a employee name table and
edit the list of employee names. then in the form where they do the
data entry, there is a drop down field where the employee names appear.
i want that field to automatically update based on the employee name
table.
--
Bas Cost Budde
Holland
Sep 28 '06 #5

This discussion thread is closed

Replies have been disabled for this discussion.