Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Controlling Combo Box functionality
Hello just wondering if anybody has any ideas on this. I have a form (containing a sub-form) which lists all order lines from a simple ordering system. On this form I have several unbound combo boxes to filter the items on the form by order number, customer name, sales assistant name and part...- aclambert
- Thread
- Replies: 4
- Forum: Microsoft: Access Forms
-
Form launches with values from first record in query
Hi everyone hoping you can help with this: I'm designing a form in Access that displays customer account records from a query, based on the selection of a record from a combo box. This works well and is straight-forward. My problem is that when the form launches it shows the details of the...- aclambert
- Thread
- Replies: 10
- Forum: Microsoft: Access Forms
-
Simple Where clause question
Hi Guys apologies if this is a newbie question. I've written a simple select statement as follows: select CONCAT(firstNames,' ' , lastName) as 'fullname' from Customers the query works fine and lists correctly. I have a name which shows as Joe Bloggs (as well as others) I then try to add the...
