• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Default Value in Subform

Attached I have an access file with three forms that are sub-forms of each other. The problem I am having is the last subform (AppointmentsSubform) when I enter the Student Name, often times on the form I have to enter like 20 appointments always with the same name.

Is there a way where after I enter the first appointment every time I click for a new appointment it will copy that first name of the booking? Possibly if I add a field on one of the parent forms and then have it default that field every time you put the curser into it.

Let me know your thoughts. Thanks!

Chris
PracticeMdb.mdb
0
cansevin
Asked:
cansevin
  • 3
1 Solution
 
als315Commented:
You can set default value for every field in subform, but if Student name is field, which you like to be filled, it isnot correct - it is filled in Bookings table and you can take it to report not storing twice.
0
 
als315Commented:
If it differs from Customer Name, it is better to store it to bookings table and also don't duplicate it.
0
 
als315Commented:
If it is also impossible, you can use some variable for storing this name (Double mouse click in Student Name Field will store and retrieve this name
PracticeMdb.mdb
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Get 10% Off Your First Squarespace Website

Ready to showcase your work, publish content or promote your business online? With Squarespace’s award-winning templates and 24/7 customer service, getting started is simple. Head to Squarespace.com and use offer code ‘EXPERTS’ to get 10% off your first purchase.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now