Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Default Value in Subform

Posted on 2011-02-18
3
Medium Priority
?
238 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 40

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 40

Accepted Solution

by:
als315 earned 2000 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 40

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

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Explore the ways to Unlock VBA Project Password Excel 2010 & 2013 documents. Go through the article and perform the steps carefully to remove VBA Excel .xls file.
Sometimes MS breaks things just for fun... In Access 2003, only the maximum allowable SQL string length could cause problems as you built a recordset. Now, when using string data in a WHERE clause, the 'identifier' maximum is 128 characters. So, …
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
With just a little bit of  SQL and VBA, many doors open to cool things like synchronize a list box to display data relevant to other information on a form.  If you have never written code or looked at an SQL statement before, no problem! ...  give i…

564 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