Code Help Please

[Gasman]

Ok here is file. Not used lookups either.

So much for that statement

 

[isladogs]

Yes you have used table level lookups for the Account field in the Ledger table. That's why you have a combo box for that field in the table.
Instead store the AccountID field in that table and link the two tables by that field for your form record source.

This is one of the reasons to avoid table level lookups. See Table Lookup Fields - Mendip Data Systems

 

[thebigman]

Oh I see what you mean a list of accounts in a dropdown so it would need the record number. I think I need to study it a bit more. Thanks again for your help.