SQL VBA form question.

[allenEd]

Hi,

SQL VBA form question.

example of the problem.

If I have two tables, table one tblnames with fields FirstName, Lastname, Dept in it.

table two tblProject, with a combo box cboLastName, which is linked to tblnames, so you can see all the fields of tblnames in the drop down.

How do I populate text boxes in a form frmProject (data from tblProject), with the FirstName and Dept, depending on what LastName the combo box says?

thanks
Allen

 

[Remou]

Presumably you only want to display this data, not save it to the projects table? If so, you can refer to the Column property of the combo in the Control Source of the textboxes, for example:

[tt]=cboPerson.Column(1)[/tt]

Column numbering starts from zero.

http://lessthandot.com

 

[allenEd]

Thanks Remou,

 

[allenEd]

It gets a litte tricky, when I save the form as a report. Then using .column(1) dosn't appear to work...

thanks

 

[Remou]

It is nearly always best to build reports. The report would use a query or sql statement based on both tables.

http://lessthandot.com