Recent content by rjohnson@Madison.k12

THANKS Dkinley and vbaINET. I used the NZ code to force them to enter a value. Then I used the Dcount to a variable to validate against the table. Here is my final code. THANKS AGAIN!!! Rick ' Validate Data based on Valid Computers Table If Me![Item Type] = "Desktop" Or Me![Item Type] =...

Hi vbaINet You stated try this and I still get a Compile Error stating "Expected =" DCount("Model","[Valid Computers]","[Item Type]= '" & Nz([Forms]![frmAssests]![Item_Type]) & "' AND [Manufacturer]= '" & Nz([Forms]![frmAssests]![Manufacturer]) & "' AND [Make]= '" &...

We've almost got it but I still get compile errors. They are All character fields so I tried this: (I get Expected: = error) DCount("Model","Valid Computers","[Item Type]= '" & ([Forms]![frmAssests]![Item_Type]) & "' AND ","[Manufacturer]= '" & ([Forms]![frmAssests]![Manufacturer]) & "' AND...

I have tried to get the syntax correct for Dcount() with multiple values but I keep getting compile errors. DCount("Model","Valid Computers","[Item Type]= & ([Forms]![frmAssests]![Item_Type]) AND Manufacturer = ([Forms]![frmAssests]![Manufacturer]) AND Make = ([Forms]![frmAssests]![Make] AND...

Thanks for these quick responses. I have been stuggling with this question for about a week. I already do a requery to rebuild the comboboxes. That works fine. I just need to validate at the end of the Form. Sometimes data gets uploaded into the Inventory Database manually and I need to...

I have made them as comboboxes, but I cannot force them to fill every combo box in sequence. If they choose to skip a box or they go back and change the Make, I can't force them to recheck the Model. How would I check to see if the record exists? (NoMatch, Dlookup, Findfirst)? Thanks Rick

I have an Inventory Table listing all Desktops, Laptops, Netbooks. I have a Valid Computer Models table. I have a Form they use to add & change Computers in Inventory. The form has multiple Comboboxes that norrow the Choices of Manufacturer, Make and Model depending on the Item Type of...