run query at runtime

[sireesha]

Hi,



I have a combox with list of deptnames. By selecting the dept corresponding employeenames display in the listbox. by selecting the employeename, i want to display the employee details in the corresponding textboxes. how?

i have tried the query, after selecting employee name, that employee name only display in the corresponding textbox. not other fields.

when i check the query it will get all details, after selection of listbox employee names.

Please help me.

Regards,
Sireesha.

[pbaldy]

Like this?

http://www.baldyweb.com/Autofill.htm

[sireesha]

Like this?

http://www.baldyweb.com/Autofill.htm

Hi,

Thanks for your reply. but in my listbox only employeenames. when i select employee name their details will display in correponding textboxes.
i tried with query passing parameter from listbox to query. after selection of listbox employeename the query gives result(i.e., empid,desg,phoneno,address etc.,). but how to connect textboxes to that query.

i've tried like this also :

Forms---> controlsource ==queryname and textboxes bound to queryfields. but its not worked.

how?

Please help me.

Regards,
Sireesha.

[pbaldy]

Well, your listbox could have more than names, could it not?

[sireesha]

Well, your listbox could have more than names, could it not?

Hi,

my listbox have only names. when i select name, those details need to be displayed in corresponding textboxes. how?

Regards,
Sireesha.

[pradeep.sands]

Hi Sireesha,
Try writing expression for it in the expression builder.

[sireesha]

Hi Sireesha,
Try writing expression for it in the expression builder.

SELECT *
FROM [table]
WHERE ((([table].[Name])=[Forms]![form1]![Name]));


[Forms]![form1]![Name] means in the form---> listbox--->have names

when is select listbox name---> all other textboxes are blank and name textbox will replace with selecting name.

i need all other textboxes need to replace with further details

Regards,
Sireesha.

[pradeep.sands]

Open your sql as a recordset so that you can move through each field and record, and try to assign each field value to the respective text box..
nametxtbox = Me.Fields(0).Value
addresstxtbox = Me.Fields(1).Value
...
...