C
carrietom
Hi, On my main form, the employee needs to enter a staff member in two
different places (one position is Abandonment Coordinator and one position is
Land Sale Coordinator).
I have Tbl_Employee (EmployeeID, Last_Name, First_Name, Position). I then
thought in my Main Form i would have a drop down field for each based on
Qry_AbandCoord and Qry_LandCoord so that the list only contains the
appropriate position - I joined the first and last names in these queries as
Name.
If the name of the employee is not on the list I would like them to be able
to add a new employee (On Not In List Event) to a pop up form. I would like
the default value to be the correct position for that field. I thought I
would need to build 2 forms (one for each position) and base them off the
table so that they can add the first and last names (please correct me if I'm
wrong) and I thought the code would be:
Forms!Form_AbandCoord!Position.Default Value="""&Abandonment Coordinator&"""
but I have tried putting it on a couple of different events and don't seem to
get any result (have also tried without the &'s). I'm sure I'm missing
something silly but appreciate the help!
different places (one position is Abandonment Coordinator and one position is
Land Sale Coordinator).
I have Tbl_Employee (EmployeeID, Last_Name, First_Name, Position). I then
thought in my Main Form i would have a drop down field for each based on
Qry_AbandCoord and Qry_LandCoord so that the list only contains the
appropriate position - I joined the first and last names in these queries as
Name.
If the name of the employee is not on the list I would like them to be able
to add a new employee (On Not In List Event) to a pop up form. I would like
the default value to be the correct position for that field. I thought I
would need to build 2 forms (one for each position) and base them off the
table so that they can add the first and last names (please correct me if I'm
wrong) and I thought the code would be:
Forms!Form_AbandCoord!Position.Default Value="""&Abandonment Coordinator&"""
but I have tried putting it on a couple of different events and don't seem to
get any result (have also tried without the &'s). I'm sure I'm missing
something silly but appreciate the help!