Search results

Hi I am having some trouble coming up with a solution so that a combobox only lists staff members at a particularly who have the relevant qualifications associated with a service. Perhaps I have the table design wrong (please see the relationship image) to do this kind of thing: Here's what I...

Hi all I am looking for a more elegant and easier/quicker form to create for inputting data into a many to many table. Here's how my tables are setup: tblPractice: PracticeID (PK-Autonumber) PracticeName ... tblEquipment: EquipmentID (PK-Autonumber) EquipmentName ... tblPracticeEquipment...

Hello I want to use an Iif statement in my query so that If a contractor has a certain value (True/False) then different records are filtered out. I have standardtypes c, h, i and b. I always want to omit "b" (<>b) but depending on the true/false value I want to show/hide "i" I have tried the...

Hi I currently have a main form (frmStandResults) and 2 subforms within tab controls. There are 2 combo boxes (Contractors and Groups) in the main form header that when updated (AfterUpdate) they requery 2 subforms that are on different tabs using the below code...

Hi I have been searching around these forums and found some great examples of things you can do with combo boxes and filters. I am trying to join 2 examples I have found but with no success. At present I have 2 different types of combo box, the first: This lists the contractors found in the...

Hi I am looking for some help in creating a form to use for data entry. Here is my situation. I have the following tables: tblContractor (pk ContractorNum - autonumber) tblStandards (pk StandardNumber - text) tblStandardsType (pk StandardTypeID) tblStandardsGroup (pk StandardGroupID)...