Populating Text Box Help NO VBA

[alee8994]

I've been working on this for several days, and nobody has been of any help, either in person or online, so this is the only thing left I can think of. I'm trying to build a database that stores shift change requests. The requests will be entered through a form by the employee's manager. I want the manager to be able to enter the employee Id code, and the name of the employee populates a text box, either automatically or by pressing a button. Simultaneouly, I want a record for a new request saved in a database, to which I can fill the additional fields through more forms later. I've tried manipulating the sources for the text boxes I'm using, but no record is being updated until I close the form, and sometimes not even then. I've also tried using macros to do this and the SaveRecord function does nothing when I attach it to a button. Any help is welcome, but PLEASE NO VBA. I have no idea how to use it and I need to get this done because I'm at my wits end.



Thanks.

[June7]

Why not use a combobox for selection of employee? Employee ID and name can be columns of combobox http://www.datapigtechnologies.com/f...combobox3.html. A textbox ControlSource can refer to combobox column by index. Index begins with 0.

=[combobox name].[Column](1)

The employee ID should be saved, not employee name.

Are you using a form bound to the table record should be saved to?

A record is committed to table when moving to another record or close form/table/query or run SaveRecord code.

[alee8994]

There are ~5000 employees, so I'm concerned managers might have trouble finding the one they are looking for.

[June7]

5000+ records might be too much for a combobox but there is VBA code to deal with that.

This is a form bound to table? Only other thing you can try that would avoid code is to include the Employees table in the form RecordSource with RIGHT JOIN "Include all records from Requests and only those from Employees that match."

Bind employee ID textbox to field from Requests table. Bind textboxes to fields from Employees table and set them Locked Yes and TabStop No.

If manager inputs valid ID into textbox, the related data from Employees should display.

This assumes EmployeeID fields are the PK/FK in both tables, not an autonumber field in Employees as primary key.