I have a split database that I am trying to help speed up a slow process. We currently have a form that our brokers are having to fill out on every lease that they open. In the subform they have 25 minimum items that need to be populated on every lease. I have loaded a table with the current minimums, the table is called tMinData, and I would like to have the two lines in the table (Code, LeaseProv) be added into the subform. Every attempt I have made tries to either duplicate the lease or fails. Any help would be appreciated!
Append Subform with Button
- Thread starter gumbi17
- Start date
- Local time
- Today, 05:00
- Joined
- Jan 23, 2006
- Messages
- 15,498
It would be helpful to readers if you would tell us in plain English WHAT you are trying to do.
Tell us about your tables and relationships. Supply a jpg if possible.
Why do users have to fill in 25 fields?
When I reread your post, I think you are saying--
when a broker creates a new lease, there are 25 fields that must be completed.
Your post, as it stands, does not supply enough info for a focused response.
Tell us about your tables and relationships. Supply a jpg if possible.
Why do users have to fill in 25 fields?
When I reread your post, I think you are saying--
when a broker creates a new lease, there are 25 fields that must be completed.
Your post, as it stands, does not supply enough info for a focused response.
WHAT I am trying to do is make an easy way to add what is within a table to input into a subform by using a button. The user have to input 25 unique fields because that is what is being tracked by management. As I said I have a table tMinData where I house the min 25 fields I would like populated into the database when then button is pressed. The min's never change, they stay the same but they are time consuming to input for every lease the broker is working with. The pic of #1 is what it looks like complete and #2 empty.
Attachments
- Local time
- Today, 05:00
- Joined
- Jan 23, 2006
- Messages
- 15,498
A form or subform is just a means of displaying data stored in a table and/or related tables.
It seems to me (easy because I'm not involved nor do I know the rules within your company) that having to manually enter 25 values to open a new lease is a bit much.
You know who the user/broker is (or could if they had to log on), you know what Day it is so some things could be generated. If you have a list of properties, then the properties would be uniquely identified and details of the property would be on file (at least some of the time)
So linking the broker, the property would/could populate part of a new lease.
What am I missing?
Do you have a data model representing the data requirements and relationships of your lease business?
It seems to me (easy because I'm not involved nor do I know the rules within your company) that having to manually enter 25 values to open a new lease is a bit much.
You know who the user/broker is (or could if they had to log on), you know what Day it is so some things could be generated. If you have a list of properties, then the properties would be uniquely identified and details of the property would be on file (at least some of the time)
So linking the broker, the property would/could populate part of a new lease.
What am I missing?
Do you have a data model representing the data requirements and relationships of your lease business?
