Solved

Default Value in Subform

Posted on 2011-02-18
3
228 Views
Last Modified: 2012-05-11
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
Comment
Question by:cansevin
  • 3
3 Comments
 
LVL 39

Expert Comment

by:als315
ID: 34928290
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
 
LVL 39

Accepted Solution

by:
als315 earned 500 total points
ID: 34928479
If it differs from Customer Name, it is better to store it to bookings table and also don't duplicate it.
0
 
LVL 39

Expert Comment

by:als315
ID: 34928689
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

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

The first two articles in this short series — Using a Criteria Form to Filter Records (http://www.experts-exchange.com/A_6069.html) and Building a Custom Filter (http://www.experts-exchange.com/A_6070.html) — discuss in some detail how a form can be…
It took me quite some time to sort out all the different properties of combo and list boxes available from Visual Basic at run-time. Not that the documentation is lacking: the help pages are quite thorough and well written. The problem was rather wh…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…

758 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now