Recent content by JamesJoey

It's not really copying the last entered value, it's the $10 that was entered for "John Doe" I might have an entry for; say my gas company payment that's $80. Or my electric bill which might be $70... Let's forget it. I never said anything about "Moving" a record. I know what a slit form is...

It's not really copying the last entered value, it's the $10 that was entered for "John Doe" I might have an entry for; say my gas company payment that's $80. Or my electric bill which might be $70...

The currency value will be different for different payees. And I do want to add or delete payees from tblPayees.

Ok. I'll try to explain this one more time. You have a split form. Split form has rows and columns. Right?? Split form has 3 columns: 'Payee' 'Debit' Credit.' Lets say there is no data at all being displayed in the spit form. This is where it gets tricky. Lets say I type "John Doe" in the...

OK. Then how do I get it to enter the data for me?

I'm typing in the values myself. That's the purpose of my wanting to auto-fill these.

I guess you didn't understand #16. Obviously since Debit and Credit are Currency fields they would be populated by currency values.

I posted the structure of the 2 tables. I want to autofill the Debit and Credit fields when I select a Payee from a Combobox.

Is there a join wizard? Not sure how to create one. Do I need to modify the current qry?

So I need to add a Debit and Credit field to tblPayees?

I have a Debit and a Credit because I don't have to remember to place a negative sign in front of the Debit value. Although I don't have Debit and Credit fields in tblPayees, only in tblFincnaces,

The only link between tblPayees and tblFinances is the Payee. I have PayName in tblPayees and the Payee field inn tblFinances. I simply select a PayeeName from the combo box and it gets stored in Payee in tblFinances. The credit and debit fields are in tblFinances.

No. The combo box is populated by tblPayees which has on 2 fields PayeeID and PayeeName

I have a table which similar to a checking registry. I also have a Payee field in my 'tblPayees' table which I use to autofill a Payee field via split form's combo box, in a checking table tblFinances. tblFinances also has 2 other fields Credit and Debit. I want to be able to auto-fill the...

'CheckingID' (Auto Number) 'CheckNumber' (Short Text) 'TransDate' (Date/Time) 'Description' (Short Text) 'Status' (Short Text) 'Credit' (Currency) 'Debit' (Currency)