Using forms and update queries

[davidman]

Hi

I want to make a form to upload new records to a table, is there any way so I can type a person's name into a field and it will list all entries from the employee list with that name, list their department, shift etc so I can select the right one to edit their record on the holiday table?

[orange]

You seem to be asking multiple questions and may need more than 1 form

a)a form to upload new records to a table
b)type a person's name into a field and it will list all entries from the employee list with that name, list their department, shift etc
C)so I can select the right one to edit their record on the holiday table?


See these for specifics and examples
http://support.microsoft.com/kb/304473
http://www.599cd.com/tips/access/form-subform/

Good luck

[June7]

What is 'holiday' table - vacation schedule?

Options for filtering a form or report:

1. dynamic parameterized query http://www.datapigtechnologies.com/f...tomfilter.html

2. code sets Filter and FilterOn properties http://allenbrowne.com/ser-62code.html

3. code constructs filter criteria and passes to the form or report when opening
DoCmd.OpenForm "form name", , , strCriteria