Search results for query: *

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...

Thought I would let you all know that I've implemented this across a few forms in my database now and it has worked in all scenarios and does exactly what I want. Thanks to all of you who had an input, you've been very generous with your advice! cheers Aaron

Thanks fneily Just to make sure I'm getting this right, does this go in the On Click Event for the button which actually launches my form or does it go on the combo box which would have me select a record to populate the fields on this form? Also, I've tried this on the combo box and it didn't...

The form I have created has the combined function of viewing account records and amending them, so it does need to be possible to update these fields. Given this response I think that still makes your original post correct, doesn't it? I haven't tried it just yet, I'm looking at something else...

That sounds like a plan, I'll give that a go! Thanks for all your help. Cheers Aaron

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...

Hi Everyone thanks for all the great advice. I'm still trying to learn so I'll take on board your comments about this being a 'hacky' way round things. Thanks! A.

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...