Auto Fill Text Box From Table

[gator9]

Ok I have a form named drafts that is linked to a table called drafts. We take payments over the phone, and most cases the checking account information is the same on every payment a client makes. What I want to do is auto fill the text box called BankName with the last entry from the last payment made and entered into that field.


Thanks

Charles

 

[databasedemon2002]

Hi,

You can use the Dlookup function to return the last record entered into the table. You can set the criteria to further limit the record that is being returned if you need to.

Also, you could use a combo box instead of the text box and have it use a default value. Anyway, there are many solutions to your issue.

Good Luck

 

[gator9]

DO you have any examples of the Dlookup that you are talking about.

Thanks

Charles