Hello Everyone.
I've run into a couple of issues and from all my reading and watching of tutorials I'm guessing I need to write some code to get to where I want to go. I could really use some help. (note, I'm using Access 2000)
I have a simple unbound data entry form (FormA) that collects this data:
Truck
WeekDay
CollectionDate
Then I have a button called "Enter Collection" and when a user hits this button I need multiple things to happen.
1. I need to validate that the user has entered a value into the three fields, Truck, WeekDay and CollectionDate.
I am really struggling with validating these three boxes. The other forms I've used are all bound to a table so it's easy to make a field required. Since this is an unbound form I'm not even sure how to begin. I've been reading and watching a lot of YouTube but I don't think I'm searching for the correct topic because I cannot seem to pinpoint how to do this.
IF the user has entered the three fields then I need to move on to the next steps (not sure if this is the proper order to do them or not).
2. Open FormB (has a SubForm in it also)
Several things happen on this form:
A) Upon opening the form the user is prompted to enter the Truck and DayWeek - manually entered the form works great. However, I would like to have the information from FormA automatically enter now.
B) This form has a Subform that is tied to a table for data entry. One of the things the user has to enter in every record is the CollectionDate - but it's the same for all the records the user is going to enter. This is why I want to collect this from FormA and then automatically enter it for the user. Is this possible?
I greatly appreciate your help. Thank you.
I've run into a couple of issues and from all my reading and watching of tutorials I'm guessing I need to write some code to get to where I want to go. I could really use some help. (note, I'm using Access 2000)
I have a simple unbound data entry form (FormA) that collects this data:
Truck
WeekDay
CollectionDate
Then I have a button called "Enter Collection" and when a user hits this button I need multiple things to happen.
1. I need to validate that the user has entered a value into the three fields, Truck, WeekDay and CollectionDate.
I am really struggling with validating these three boxes. The other forms I've used are all bound to a table so it's easy to make a field required. Since this is an unbound form I'm not even sure how to begin. I've been reading and watching a lot of YouTube but I don't think I'm searching for the correct topic because I cannot seem to pinpoint how to do this.
IF the user has entered the three fields then I need to move on to the next steps (not sure if this is the proper order to do them or not).
2. Open FormB (has a SubForm in it also)
Several things happen on this form:
A) Upon opening the form the user is prompted to enter the Truck and DayWeek - manually entered the form works great. However, I would like to have the information from FormA automatically enter now.
B) This form has a Subform that is tied to a table for data entry. One of the things the user has to enter in every record is the CollectionDate - but it's the same for all the records the user is going to enter. This is why I want to collect this from FormA and then automatically enter it for the user. Is this possible?
I greatly appreciate your help. Thank you.