Auto-Filling 2 Form Fields

[JamesJoey]

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 Payee column. Then I type $10.00 in the Debit column. The value can go in either Debit or Credit but not both.
I save it.
Tomorrow, I add a new record. I type "John Doe" in the Payee column. and put nothing in the credit or debit columns.
After saving the record I want the $10.00 to automatically be place d in the Debit column because that was the last value I put in for "Jahn Doe."

I'm unable to explain this much clearer so if you guys still don't understand, let's just forget the thread.

 

[Mark_]

OK, so you are looking for "How do I find the LAST RECORD BY SORT ORDER to default a new record's value"?
Create a TOP 1 query on tblChecking ordered by TransDate, payee, and your credit / debit fields.
DLookup your query using the Payee.

Course if you have changed values in your payee table, this won't work as you are doing a by value lookup.

NOTE: Personally I wouldn't do this. Then again I'd not have separate "Credit" and "Debit" fields, I wouldn't do a by value lookup, nor do I think this will be of benefit. Rather I'd simply make sure the user could see the previous transactions for this payee.

 

[JamesJoey]

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

 

[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...

 

[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...

We're back to the where question again. WHERE is this amount coming from? Why are you talking about moving/copying it? Are you saying that you do NOT want to enter data in either the Debit or the Credit field? Well then, WHERE do you want to enter it and how is the application supposed to know which column to move it too.



Also, "Split form" is a very specific type of form that can be created via the interface and I doubt that you are using one. It has both a single record form and a list of rows on the same form. If you change either, the other will automagically populate. If you click on a different item in the list part of the form, then its single record form is shown. The single record form ALWAYS matches the Current row from the list part of the form.

Let's forget it.
I never said anything about "Moving" a record.
I know what a slit form is. 90% of my forms are split forms.
Besides if I have a record (Row) I want to duplicate I can copy and paster the record. I just need change the TransDate.

 

[Gasman]

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 Payee column. Then I type $10.00 in the Debit column. The value can go in either Debit or Credit but not both.
I save it.
Tomorrow, I add a new record. I type "John Doe" in the Payee column. and put nothing in the credit or debit columns.
After saving the record I want the $10.00 to automatically be place d in the Debit column because that was the last value I put in for "Jahn Doe."

I'm unable to explain this much clearer so if you guys still don't understand, let's just forget the thread.

Well your initial post was way off what you have just said.
Why could you have not said that in the first place?

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 Credit and Debit fields when I select a payee form the combo box. (I used the combo box wizard to create this combo box.)
tblPayee has 2 fields (PayeeID and Payee.