outputting value from listbox to text box

[Aidanb]

Hi all,

I am wondering if it is possible to have a value put in a text box in a datagrid from a Listbox.

I have a recipe database and i want to be able to quickly select items out of a list box for each supplier which needs to be filtered through a combobox. once double clicked the item needs to be put in to the next available cell in a datagrid subform.

Hope this makes sense

also is there a way the contents could be reduced by typing in the letters of the item you are trying to find (a little like intellisense).

Thank you in advance.

Aidan

 

[John Big Booty]

Hi all,

I am wondering if it is possible to have a value put in a text box in a datagrid from a Listbox.

I have a recipe database and i want to be able to quickly select items out of a list box for each supplier which needs to be filtered through a combobox. once double clicked the item needs to be put in to the next available cell in a datagrid subform.

Hope this makes sense

..........

You could do this with a sub form populated by query that uses the current record (selected in the list box) as it's criteria.

.....

also is there a way the contents could be reduced by typing in the letters of the item you are trying to find (a little like intellisense).

Thank you in advance.

Aidan

Perhaps this search tool would do what you are looking for.

 

[John Big Booty]

Here's a sample DB that might be headed in the direction you are looking for.