Paws for Thought
New Carer Form
Requirements
The customer wanted the form to be able to input a new carer’s information such as their name,
surname, ID and their email into it. This was achieved by implementing text boxes onto the form.
This allowed the user to type information into the boxes, which would be stored and ready for
future use. The customer also wanted to allow the forms data to be added to a database. This was
achieved by using a lookup wizard which linked the form and the table together, letting the form
reference it. However, this on its own will not be sufficient to meet their requirements. The form will
also need a button to tell the form when to add the record. This button will use VBA to take the
textboxes values and add them to the suitable fields within the table.
Events in solution
, Design
Screenshots
Created a Form
Opened “Carers”
Table
,New form created
Went into the
“Validation Rule”
Inputted a rule to
only allow email in
the correct format
, Creating a “Add
New Record”
button
Changing the text
on the button
New Carer Form
Requirements
The customer wanted the form to be able to input a new carer’s information such as their name,
surname, ID and their email into it. This was achieved by implementing text boxes onto the form.
This allowed the user to type information into the boxes, which would be stored and ready for
future use. The customer also wanted to allow the forms data to be added to a database. This was
achieved by using a lookup wizard which linked the form and the table together, letting the form
reference it. However, this on its own will not be sufficient to meet their requirements. The form will
also need a button to tell the form when to add the record. This button will use VBA to take the
textboxes values and add them to the suitable fields within the table.
Events in solution
, Design
Screenshots
Created a Form
Opened “Carers”
Table
,New form created
Went into the
“Validation Rule”
Inputted a rule to
only allow email in
the correct format
, Creating a “Add
New Record”
button
Changing the text
on the button
