Search results

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)

I do want it to be editable. I was under the impression that one can create formula for an unbound field that displays the balance between the 'Credit' and 'Debit' currency values.

I'm using a continuous form, and yes I am able to edit it. I'm trying to create a checking account register. I didn't realize it was so difficult.

I thought it worked. It is placing the value of either the Credit or Debit in each row. It doesn't give me a running total.

That worked fine. It was difficult for me to read it and just took a guess. Thank, James

I'm trying to create a query that adds the Credit column and subtracts the Debit column, like a checking registry. I've created the table. I got this example from a video on the web. I created a query with all fields in table plus a 'Balance' field for a calculated field: So far all I get is...