var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Lookup type functions.
For simplicity sake:
I have 1 table (A) with two fields. Boss & Secretary.
I have 1 table (B) with many fields, including Boss & Secretary.
I've created a Form to modify Table B. On the form, I created a Drop Down list from which I can choose the name of a Boss from Table A (field is actually linked to table A).
What I want is for the secretary field on the Form (used to modify table B) to auto-populate based on the selection I make in the Boss field.
I'm basically wanting to choose an item in one field and then have the other fields auto-populate based on the choice I made and it's corresponding data in a second table.
I toyed around with Dlookup but I'm not exactly an expert.
Any help is appreciated.
Suppose you have comboboxes cboBoss and cboSecretary. Then in afterupdate event for cboBoss put following code.
cboSecretary.Rowsource = "Select Secretaty From tblA Where Boss='" & me.cboBoss & "';"