Hello there,
I'm in the process of designing a form for the usr to key some data, there are some repetitive data that I would like to populate automatically depending on the entry.
I've created a Mainform/subform for the same table with the fields on the mainform:
date
hourly intervals
subform:
date (auto pop from mainform entry)
hourly interval (auto pop from mainform entry)
name
# of calls
The process is:
date is entered,
hourly interval (1/2 hour ie. 8:00, 8:30)
then tab to go to the name field of the subform
then # of calls.
1) is this a good design or is there a better type of form that I can utilize.
2) I'm having problems with the subform adding a new blank line (not the new record line) when you go back to view the past entries.
3) I would like the subform to go to the new record line when viewing past entries.
4) when viewing the past entries, some of the entries are not seen due to the record scrolling to the middle of the table, you need to page up to see all the entries.
bottom line this is a bad form and my main objective is to have the ability to enter the date then the interval time then the records from these entries, change the interval time to be able to enter new entries from the date+interval time info.
please help....
Kastaman
I'm in the process of designing a form for the usr to key some data, there are some repetitive data that I would like to populate automatically depending on the entry.
I've created a Mainform/subform for the same table with the fields on the mainform:
date
hourly intervals
subform:
date (auto pop from mainform entry)
hourly interval (auto pop from mainform entry)
name
# of calls
The process is:
date is entered,
hourly interval (1/2 hour ie. 8:00, 8:30)
then tab to go to the name field of the subform
then # of calls.
1) is this a good design or is there a better type of form that I can utilize.
2) I'm having problems with the subform adding a new blank line (not the new record line) when you go back to view the past entries.
3) I would like the subform to go to the new record line when viewing past entries.
4) when viewing the past entries, some of the entries are not seen due to the record scrolling to the middle of the table, you need to page up to see all the entries.
bottom line this is a bad form and my main objective is to have the ability to enter the date then the interval time then the records from these entries, change the interval time to be able to enter new entries from the date+interval time info.
please help....
Kastaman
