Hello to everyone my question is this :
i'm trying to build a form that will work by the following principle : a user input's date in field [Date] and department in [Dep] (dep is number)
the effect im trying to get is - access automaticly searches the DB and if it finds a record to match both the criterion, it displays that record, if not access opens a new record for input with those values...
the date is inputed by that that the user double click's the date field and the depart simpe written as a number value
i've tried to do with dlookup inside another dlookup but that is not correct logical expression
I'm really hopeless about that one HELP PLEASE
i've included the example DB with just the table, query and 2 forms needed.
i'm trying to build a form that will work by the following principle : a user input's date in field [Date] and department in [Dep] (dep is number)
the effect im trying to get is - access automaticly searches the DB and if it finds a record to match both the criterion, it displays that record, if not access opens a new record for input with those values...
the date is inputed by that that the user double click's the date field and the depart simpe written as a number value
i've tried to do with dlookup inside another dlookup but that is not correct logical expression
I'm really hopeless about that one HELP PLEASE
i've included the example DB with just the table, query and 2 forms needed.
