I have a simple database with one table(Issue log). What I want is a form that allows for creating a new "issue" within the table or updating the status of an existing issue.
I want the form (Issue log) that will update an issues' status to auto-populate based on which issue number you enter.
Example: I open the form and put 10 in the issue number line in the form and the other fileds populate based on the entry for 10 in the table.
I'm currently trying to use Dlookup but I can't get my syntax right. Here's what I've entered:
=DLookUp("[Issue name]","Issue log","[Issue number= " & [Issue number])
Also, I want to eventually make the form pupoulate based on the most recent entry for an issue based on the date stamp in the table.
Any help would be greatly appriciated