Search results

Hi, I have a combo that I want to populate using an SQL SELECT query. The source table records have a Customer text field together with a LiveOrder checkbox field which is unchecked if the customer has a live order. However, if a customer has more than one LiveOrder the customer's name appears...

Hi, I've almost got it working (more by luck than knowledge!), just one fairly minor problem to sort out. The combo on the Contacts form (cboContactSelect) is UNBOUND. I've added the following SQL to the combo's ROW SOURCE: ------------------------------------ SELECT...

I've messed about with bound/unbound, manual/wizard and to be honest I got a bit lost! :eek: What I want to achieve is a combo on the Contacts form which displays the 'FirstName', 'LastName' fields for the contacts associated with the selected customer, which then allows a particular...

Hi, This is a Nooby question that's probably been answered before but I can't find reference to it using the search facility, so I apologize if this is a FAQ. I have two forms (Customers and Contacts). On frmCustomer I have a button (btnManageContacts) which I want to open frmCustContacts and...

Wow! that was quick. Many thanks Bob, that's exactly what I was looking for. I've also bookmarked the linked site as well which appears very useful for a beginner. Cheers.... mike

Hi, Fairly novice question I guess, but I used the Form Wizard to construct a data entry form from a single table, and added all fields from the table. I now want to re-size a couple of the Text Boxes on the form but they all appear to be grouped together and when I resize one Text Box they all...