Combo Box Help VBA total newby help

[kiamba]

I am a newby and need the combo box to fill in the details as per the attached picture, any help would be appreciated

thank you

[ssanfu]

Welcome to the forum.


Not a lot to go on.

What/which combo box?
What details filled in to which controls?
Looks like you have two controls with problems with the control source. (#Name?)

Maybe post your dB for analysis?

[kiamba]

the problem i have is i have been handed this to try and fix and get working, so i have no idea what has been done in the past

the combo box is the client name and need and once the company is selected need it to fill in the client contact, the client phone number, client address and contractor email,

sorry i am probably not explaining myself properly

total newby

[Micron]

Your level of expertise might make this difficult to solve, especially since you haven't specifically stated what the problem is. I suspect it is the #Name error in the form controls. We might nail down the reason in one post but if you have no idea how to follow up and rectify, this could go on for quite a bit. I'll suggest that the control source for those textboxes starts with = and the control and the field have the same name. If you can follow up on suggestions like that, then great. That follow up would involve explaining why the controls are not just bound to a query or table rather than using an expression (something that starts with =) as their controlsource. If you can't do that, maybe you can copy the db, remove whatever is not necessary to replicate the problem, test that it still occurs, then compact and zip the db and post it here. See how to attach files button at the top of the forum page.

[June7]

Could provide db for analysis. Follow instructions at bottom of my post.

Options for displaying related client info:

1) Have Client combobox RowSource be a query that includes all client info. Set combobox ColumnCount and ColumnWidths properties relative to number of fields. Then textboxes reference combobox columns by their index. Index numbering begins with 0. So, if client name is in column 2 its index is 1.
=cbxClient.Column(1)

2) Include Clients table in form RecordSource then bind textboxes to Clients fields - set those textboxes as Locked Yes and TabStop No to prevent edit.

[kiamba]

removed file

[June7]

Many here will not download from external source. Best to attach to post.

Did you try either of the suggestions I provided?