DLookup Code Not Working

[burrina]

DLookUp("startingbalance","TBanks","bankid = " & [bankid])



I am trying to use this to lookup the startingbalance from table TBanks and use as the default value on a textbox but I get no errors, just no data?
bankid is the primary key and TBanks is the table and startingbalance is the field I want to lookup!

The form where the textbox is located is named FReg and has its primary key as RegID

[Bob Fitz]

I'm not sure but I think your problem is that the default is only used on a new record. But on a new record [bankid] has no value.

[burrina]

Well, actually the form has many records.

[Bob Fitz]

If I'm right about the problem, it doesn't matter how many records you have. What matters is that the Default Value is only invoked with a new record, but in a new record [bankid] has no value.
Perhaps you could use:
= DLookUp("startingbalance","TBanks","bankid = " & [bankid])
as the Record Source property of a textbox.

[burrina]

Hmm, tried that with no luck. And yes you were right, no value for bankid due to the unique way the form is. Have to figure something else out or the user has to enter it manualy! Not good.

[Bob Fitz]

When and how does bankid get populated with a value.

[burrina]

It gets populated via a popup form where you choose the bank. Also due to some unusual things with the form it also uses this code on the on open event.
Me.Bank.DefaultValue = """" & Me.Bank.Value & """"



Is there a way for me too copy over the values of the fields from the bank form to the check register form?
The bank form has all of the info I need such as starting balance and I need to get this info onto my check register form. I attach a screenshot of the bank form. Can I do a insert or something else to automate this? Fields I need to copy over are;
startingbalance
startingchecknumber
lastbankstatementbalance
lastreconciliationdate

[burrina]

I used my popup form to solve this and did a copy data over routine.