I have a form that has an unbound text box which holds total loan amount and I have locked the text box (greyed out) . The default value is set to $140,000. On the form there is a check box which allows the user to unlock the text box and change the default loan value. Two things I can't seem to get working. 1. I am able to change the default value but the value won't hold after I close the form and re-enter the form. The value goes back to $140,000. I'm sure I need some type of coding because the text box is unbound but I can't seem to get it. My other question is when I change the default loan value how do I make it consistent for all records. (All records will have the same loan amount) The loan value should be consistent thorughout all records as only 1 loan will exist for many users. Any help would be greatly appreciated, thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Default Text Value 2
- Thread starter smicro
- Start date
-
1
- #2
All records will have the same loan amount
Have a look here:
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
Have a look here:
Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886
- Thread starter
- #3
Thanks PHV,
I'm still having some trouble on this. Can you give me a hint? I created a separate table that has
1.LoanAmount
2.CustomerID. Loan amount is the primary key.
The other table contains
1.Customer ID as the primary key
2.All related cusomter information.
I attempted to link the two tables but I can't get it to allow me to have the same loan amount for all customer ids.
I'm sure it's the design but I'm not sure where to go from here.
I'm still having some trouble on this. Can you give me a hint? I created a separate table that has
1.LoanAmount
2.CustomerID. Loan amount is the primary key.
The other table contains
1.Customer ID as the primary key
2.All related cusomter information.
I attempted to link the two tables but I can't get it to allow me to have the same loan amount for all customer ids.
I'm sure it's the design but I'm not sure where to go from here.
-
1
- #4
I think what u need to do is..
at the first table..
make another filed which u didnt use
1)CUSTOMER_ID AUTONUMBER PRIMARY KEY
2)CUSTOMER NAME TEXT
3)AMOUNT CURRENCY
for amount SET THE DEFAULT VALuE BELOW AS =140000
OTHER TABLE
1)customer_detail_id autonumber primary key
2)customer name : use the look up wizard to get the values from the first table if suceded,it will look like a combo box.)
get back to the form, throw away the current amount text box and the customer id text box. Put in the new one which you have to drag from the field name at the toolbar..(u know where it is,right?)
at the first table..
make another filed which u didnt use
1)CUSTOMER_ID AUTONUMBER PRIMARY KEY
2)CUSTOMER NAME TEXT
3)AMOUNT CURRENCY
for amount SET THE DEFAULT VALuE BELOW AS =140000
OTHER TABLE
1)customer_detail_id autonumber primary key
2)customer name : use the look up wizard to get the values from the first table if suceded,it will look like a combo box.)
get back to the form, throw away the current amount text box and the customer id text box. Put in the new one which you have to drag from the field name at the toolbar..(u know where it is,right?)
- Status
Similar threads
- Locked
- Question