hi Terry,
assuming badge is the PK of tablename, make a combobox with properties such as this:
Name:badge
ControlSource: badge
RowSource:
SELECT badge, EmployeeId, EmployeePin
FROM tablename
ORDER BY badge
ColumnCount: 3
ColumnWidths: 1;1;1
ListWidth: 3.2
textboxes:
ControlSource:badge.column(1)
ControlSource: badge.column(2)
warm regards,
Crystal
________________________________
From: Terry Olsen
For a new entry, I have a data entry form that I want to reduce keystrokes on.
In one bound control, badge, after initial data entry, I want to populate three other text boxes, txtEmployeeId, txtEmployeePin, and txtEmployeeID. After all entries on the form are complete, I want to populate fields in the DB table columns for each of them.
Which event do I use?
What persists the data to the relevant DB record?
Thanks
Terryomsn
[Non-text portions of this message have been removed]
Tidak ada komentar:
Posting Komentar