Deadline Monday, Search Form answer MUST be easy...

[todobfl]

Hello all, I am (obviously) a rookie to Access. Creating a database to store information about contract employees. Plan on splitting the database so everything will be run through forms (too many cooks to spoil the hard work).
Have four tables matching the four types of data we store:
tblInfo_ID - "main table" stores names, address, email etc.
tblCertDates - info on 3 certifications we require and dates tests taken
tblOverUnder - Over/Under as per follow-up reviews
tblQAScores - Customer Service Scores

All but the tblInfo_ID will have many entries for each employee

My problem as silly as it sounds is I need a header that is a search on a last, first name on multiple forms as the data is updated monthly and I plan on turning off the ability to move between records, so as not to allow editing of ANYTHING, only inputting new data.



Process works like this: Office support person searches on a person by name (they are stored in two separate fields, have querry that combines to last,first) and then either through tabs or separate forms is able to enter the new months data for that person. The ID for each employee is an autonumber.

I keep getting close but no cigar. I feel helpless. Thanks for any and all help.

[rpeare]

So you want to be able to select a person and have your form go to a new data entry record for that client? That's all?

I'm assuming your have a form with subforms that are all linked appropriately? If so you could have a list box and/or a search text field where you select the client then just have your form based on a query that is looking up the specific ID for that client and forcing the form to go to a new record

you would just have to use the REFRESH command once you select a person to re-populate the form with your currently selected person.

[alansidman]

If rpeare's assumption is correct, then here is a tutorial to help you get what you need.

http://www.datapigtechnologies.com/f...tomfilter.html

Alan

[todobfl]

Thas a TON for your response, the video was a great help. Filter works great now, only issue remaining is one of ease of use for date inputters...

Choosing the employee have setup just like your companies, with the EmpID along with the Name, EmpID does or does not show in drop down list (doesn't matter). However, I need the EmpID to populate in the form below so when the form is updtated that data is attached to that employee. I can have them copy it now, but that seems silly since it shows in the line above.

Thanks again and sorry for being so new!

[alansidman]

In the field for the Employee ID on the form, in the properties for the field in the default value, type =comboxname.column(0). This should populate the field with the employee ID. I am assuming that the employee Id is your PK and is located in the first column in your query.

Alan

[June7]

My experience has been that referencing Column index doesn't work in Access controls. However, it should not be necessary. Simply referring to the combobox will retrieve the Value property (Value is default). It is also my experience that the Default property setting of a control doesn't work for bound controls. Whatever is in the table overrides the default and if the table has Null or empty string, that is what will populate the box. You would have to set the default property in the TABLE itself. Alternative is to use code (I use VBA) to populate the ID field of the new record.

If this were a form/subform(s) arrangement this would be simplified. Main form bound to tblInfo_ID, subform bound to other table. Master/child link properties of the subform container would synchronize the related records. New record in child table would automatically populate the FK ID field as soon as other data is entered in the record.

[todobfl]

I cannot thank you enough. Still work to do making it "pretty", but deadline will be met.

Thank you, thank you!!