Recent content by smith.stuart

Thank you thart21, that worked. Column count property set to 1 to only show in the combo box what I wanted the end user to see, even though the combo box contained three columns. Cheers.

Thank you very much...that worked!

In the VB Editor on the left hand side there is list of forms in the project under Microsoft Access Class Objects. However all of my forms are not listed. There is nothing special about these forms. Any ideas?:confused:

Thanks for the reply but not quite what I wanted. The text box is not for displaying what is in the combo box but a field that is in the same record. For example, if a table had first names and surnames as two seperate fields in a table and I chose a first name in the combo box I want the...

Ok I'm ripping my hair out here. Very simply I want to update a text box's text after selecting a value from a combo box. The items in the combo box are taken from a field in say Table1 and the text box must display a field from the same record in the same table. However, I can't get the text...

Is it possible to create queries on the fly, i.e. I am creating a database that is to search for a word in a field (field contains a sentence) but that word could be absolutely anything. How do I create a query that is generic but contains that word as and when it is entered into say a search...

I am looking to develop a knowledge base of problems with suggested solutions. How could I start to develop one using Access? How would I make it searchable - do I need to put in keywords for each problem and solution? Any help would be appreciated as this is for a college project. Thanks in...

Having created a form from a table using the autoform wizard, how do i change / update the filelist. I have updated my table with new field additions but these new fields aren't appearing in the filelist