auto fill text box from dependent combo box

[tommyried]

can anyone please help me on this issue i have dependent combo boxes which is working fine what i want is to select the value from the list and the text box should be filled in my case it is attachement field i want to fill up the value based on combo boxes selection.I have attached the database also.



Thanks,

[June7]

Since the form is bound, what you need to do is move to the desired record or filter the form recordset. Here is one method http://datapigtechnologies.com/flash...tomfilter.html

[tommyried]

Hi June

I saw your link but its not dependent combo box to filter the form recordset,what i saw in the link is just one combo box to filter the records. I want to select the value from second combo box to filter the recordset please if possible can you modify the attached DB.

Thanks for your support

[June7]

Doesn't matter if your comboboxes are dependent. The technique is the same. Have the query parameter refer to your second combobox.

You might find disussion in this thread of interest https://www.accessforums.net/queries...ing-25758.html

[tommyried]

June Please help iam not able to figure it out i tried to change the expression in operating system but it doesnt show up anything the problem is the text feild which is attachment in my DB.

[June7]

Change the form's RecordSource to:

SELECT [Operating systems].Attachments, [Operating systems].Attachments.FileName, [Operating systems].[Subsystem ID], [Operating systems].[Operating System] FROM [Operating systems] WHERE ((([Operating systems].[Operating System])=[Forms]![Form1]![Combo2]));

Then code in the AfterUpdate event of Combo2:
Me.Requery

[tommyried]

thanks june for your kind support its working now