If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Field value as default on subform
How can I make a value on a form the default value on a subform?
|
#2
|
|||
|
|||
Field value as default on subform
It sounds like you are saying you want to record the same value in two
different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
#3
|
|||
|
|||
Field value as default on subform
I've got a main form Event with a field Duration showing how long the event
is predicted to last. On the subform I've got attendance details and a field Duration to show how long the event actually lasted. Most likely it will be the same amount of time which is why I wanted the default value from the main form. Is there a better way? "Jeff Boyce" wrote: It sounds like you are saying you want to record the same value in two different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
#4
|
|||
|
|||
Field value as default on subform
So it isn't the same field, it's something like [PredictedDuration] and
[ActualDuration]? I'm still somewhat puzzled, though. If your main-form/subform construction is standard, the subform refers to a "many" table, related to the main-form (the "one" table). I would think that "predicted" and "actual" are both characteristics of the event, not one related to the event and the other related to some kind of "child" record. What are you pointing that subform at? Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... I've got a main form Event with a field Duration showing how long the event is predicted to last. On the subform I've got attendance details and a field Duration to show how long the event actually lasted. Most likely it will be the same amount of time which is why I wanted the default value from the main form. Is there a better way? "Jeff Boyce" wrote: It sounds like you are saying you want to record the same value in two different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
#5
|
|||
|
|||
Field value as default on subform
The same EventName can be attended by many people on different dates at
different locations. "Jeff Boyce" wrote: So it isn't the same field, it's something like [PredictedDuration] and [ActualDuration]? I'm still somewhat puzzled, though. If your main-form/subform construction is standard, the subform refers to a "many" table, related to the main-form (the "one" table). I would think that "predicted" and "actual" are both characteristics of the event, not one related to the event and the other related to some kind of "child" record. What are you pointing that subform at? Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... I've got a main form Event with a field Duration showing how long the event is predicted to last. On the subform I've got attendance details and a field Duration to show how long the event actually lasted. Most likely it will be the same amount of time which is why I wanted the default value from the main form. Is there a better way? "Jeff Boyce" wrote: It sounds like you are saying you want to record the same value in two different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
#6
|
|||
|
|||
Field value as default on subform
So [ActualDuration] is a characteristic of a specific instance of [Event]?
And most of the time, it is the same as [PredictedDuration]? If most of the time it's the same, why bother to re-record it, over and over again? Why not record the [ActualDuration] only when it varies from the [PredictedDuration]? That way, you could use a query to return the [ActualDuration] (if it is entered), or the [PredictedDuration] (if it didn't differ). JOPO (just one person's opinion) .... and if you absolutely must have a duplicate(d) value in each sub-form record, take a look at using the sub-form's BeforeUpdate event to load up that field. No need to set it as default, just write it before finalizing the sub-form record. Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... The same EventName can be attended by many people on different dates at different locations. "Jeff Boyce" wrote: So it isn't the same field, it's something like [PredictedDuration] and [ActualDuration]? I'm still somewhat puzzled, though. If your main-form/subform construction is standard, the subform refers to a "many" table, related to the main-form (the "one" table). I would think that "predicted" and "actual" are both characteristics of the event, not one related to the event and the other related to some kind of "child" record. What are you pointing that subform at? Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... I've got a main form Event with a field Duration showing how long the event is predicted to last. On the subform I've got attendance details and a field Duration to show how long the event actually lasted. Most likely it will be the same amount of time which is why I wanted the default value from the main form. Is there a better way? "Jeff Boyce" wrote: It sounds like you are saying you want to record the same value in two different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
#7
|
|||
|
|||
Field value as default on subform
Good point. I'll have to have a rethink.
I've no idea how to use BeforeUpdate should I need it. Where can I get some help on using these sort of properties? Thanks for your help. "Jeff Boyce" wrote: So [ActualDuration] is a characteristic of a specific instance of [Event]? And most of the time, it is the same as [PredictedDuration]? If most of the time it's the same, why bother to re-record it, over and over again? Why not record the [ActualDuration] only when it varies from the [PredictedDuration]? That way, you could use a query to return the [ActualDuration] (if it is entered), or the [PredictedDuration] (if it didn't differ). JOPO (just one person's opinion) .... and if you absolutely must have a duplicate(d) value in each sub-form record, take a look at using the sub-form's BeforeUpdate event to load up that field. No need to set it as default, just write it before finalizing the sub-form record. Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... The same EventName can be attended by many people on different dates at different locations. "Jeff Boyce" wrote: So it isn't the same field, it's something like [PredictedDuration] and [ActualDuration]? I'm still somewhat puzzled, though. If your main-form/subform construction is standard, the subform refers to a "many" table, related to the main-form (the "one" table). I would think that "predicted" and "actual" are both characteristics of the event, not one related to the event and the other related to some kind of "child" record. What are you pointing that subform at? Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... I've got a main form Event with a field Duration showing how long the event is predicted to last. On the subform I've got attendance details and a field Duration to show how long the event actually lasted. Most likely it will be the same amount of time which is why I wanted the default value from the main form. Is there a better way? "Jeff Boyce" wrote: It sounds like you are saying you want to record the same value in two different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
#8
|
|||
|
|||
Field value as default on subform
You'll need to plan to spend some time learning to use the events that
Access forms and reports offer. As a very simple approach, try looking up BeforeUpdate in Access HELP. Also try using MS Access BeforeUpdate as search terms on-line. Good luck! Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... Good point. I'll have to have a rethink. I've no idea how to use BeforeUpdate should I need it. Where can I get some help on using these sort of properties? Thanks for your help. "Jeff Boyce" wrote: So [ActualDuration] is a characteristic of a specific instance of [Event]? And most of the time, it is the same as [PredictedDuration]? If most of the time it's the same, why bother to re-record it, over and over again? Why not record the [ActualDuration] only when it varies from the [PredictedDuration]? That way, you could use a query to return the [ActualDuration] (if it is entered), or the [PredictedDuration] (if it didn't differ). JOPO (just one person's opinion) .... and if you absolutely must have a duplicate(d) value in each sub-form record, take a look at using the sub-form's BeforeUpdate event to load up that field. No need to set it as default, just write it before finalizing the sub-form record. Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... The same EventName can be attended by many people on different dates at different locations. "Jeff Boyce" wrote: So it isn't the same field, it's something like [PredictedDuration] and [ActualDuration]? I'm still somewhat puzzled, though. If your main-form/subform construction is standard, the subform refers to a "many" table, related to the main-form (the "one" table). I would think that "predicted" and "actual" are both characteristics of the event, not one related to the event and the other related to some kind of "child" record. What are you pointing that subform at? Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... I've got a main form Event with a field Duration showing how long the event is predicted to last. On the subform I've got attendance details and a field Duration to show how long the event actually lasted. Most likely it will be the same amount of time which is why I wanted the default value from the main form. Is there a better way? "Jeff Boyce" wrote: It sounds like you are saying you want to record the same value in two different tables (i.e., one table for the main form, another table for the subform). Why is that? Using a relational database like Access, you shouldn't need to. More info, please... Regards Jeff Boyce Microsoft Office/Access MVP "Saylindara" wrote in message ... How can I make a value on a form the default value on a subform? |
Thread Tools | |
Display Modes | |
|
|