ComboBox for Record Selection 1

[Elvis72]

I have a Main Form that Shows an individuals resume information.

I also have the Projects and Proposals that we work on in the same Database.

I would like to have a subform on the Resume Main Form that has a ComboBox that you can select the Project or Proposal they are working on to create a record.

Like this:

Combobox = Title
Text Box = Client
Text Box = Location
ComboBox = PlantType

So you would select the Title out of the ComboBox and the rest would populate on their own?

 

[Remou]

Set the RowSource of the combo to a statement that selects all the relevant fields. Set the column count for the combo. In the After update event for the combo set the various textboxes to a suitable value:

Me.txtClient=Me.cboProposal.Column(2)

Remembering that numbering starts from zero.

 

[Elvis72]

Well this is what I did with the Rowsource....which I think is wrong because nothing shows in the drop down?

SELECT QryProjectResumeInfo.[Job/ProposalNo], QryProjectResumeInfo.Client, QryProjectResumeInfo.Title FROM QryProjectResumeInfo ORDER BY [Job/ProposalNo], [Client];

 

[Remou]

Does the row source query work as a query? Have you set a suitable bound column and column count? Have you set up column widths?