Recent content by DaveS

This code is supposed to run through the start date to the end date that the user supplys on the form and then check a condition in one table and populate another table based on that check. The problem is that it is not handling the dates correctly so I think there is something wrong with the...

Never mind i figured it out.

I want to take a number in a text box and compare it to a field returned by a query. This is what I have so far. Dim db As Database Dim rs As Recordset Set db = CurrentDb Set rs = db.OpenRecordset("Open Call Query") If Me.Decom_Terminal = rs.Terminal Then MsgBox "There is an open trouble call...

unfortunately this is an existing database and I can not make different tables. I have a combo box on a form named "Terminals". I want the after update event to run after someone enters a terminal to chech the "Calls" table to see if this terminal is commisioned. To do this I need to verify...

I have a combo box on a form that I wish to validate using three fields in a table called "Calls". My problem is I want the form to take the number entered search through the table and if it finds the same record then to message the user. I have no idea even how to begin this, any help would be...