|
|
Reuse a form
I created a sub-form and it has a record source that list all the records
pertaining to a given ID. This works fine.
Now however, I would like to reuse this sub-form in a new form but only
display the last date entry.
How can I do this? I am trying to avoid creating a new form, because that
just leads to updating nightmares, keeping multiple versions in sync... I am
sure there is an easy way to do this that I am simply not aware of.
Thank you for the help,
QB
|
|
0
|
|
|
|
Reply
|
 Utf
|
12/8/2009 6:18:01 PM |
|
Why not just set the recordsource to a different query through code?
--
Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)
"QB" <QB@discussions.microsoft.com> wrote in message
news:904ABD28-0257-4BC1-8795-7EE1C3B9E1F0@microsoft.com...
>I created a sub-form and it has a record source that list all the records
> pertaining to a given ID. This works fine.
>
> Now however, I would like to reuse this sub-form in a new form but only
> display the last date entry.
>
> How can I do this? I am trying to avoid creating a new form, because that
> just leads to updating nightmares, keeping multiple versions in sync... I
> am
> sure there is an easy way to do this that I am simply not aware of.
>
> Thank you for the help,
>
> QB
|
|
|
0
|
|
|
|
Reply
|
Douglas
|
12/8/2009 6:38:25 PM
|
|
A thought is to have a DMax on your main form with button for Last_Entry.
then include these in the Record Source for the subform.
--
Build a little, test a little.
"QB" wrote:
> I created a sub-form and it has a record source that list all the records
> pertaining to a given ID. This works fine.
>
> Now however, I would like to reuse this sub-form in a new form but only
> display the last date entry.
>
> How can I do this? I am trying to avoid creating a new form, because that
> just leads to updating nightmares, keeping multiple versions in sync... I am
> sure there is an easy way to do this that I am simply not aware of.
>
> Thank you for the help,
>
> QB
|
|
|
0
|
|
|
|
Reply
|
Utf
|
12/8/2009 7:19:02 PM
|
|
|
2 Replies
392 Views
(page loaded in 0.323 seconds)
Similiar Articles: How do I reuse label sheets when I don't use the whole page ...I have a set of eight toggle buttons on an Access form that are arrayed in two ... How do I reuse label sheets when I don't use the whole page ... I need a way to print ... How do I turn on Autocomplete in Access 2003 Forms? - microsoft ...If what you are saying is you want to be reuse the the value entered in a control ... microsoft.com... > > > > How do I turn on Autocomplete in Access 2003 Forms? Session timeouts with forms authentication - microsoft.public.crm ...We have a customer using CRM in a hosted environment, setup to use forms ... State management: Session timeout set to 60 minutes *CRMAppPool in IIS **Recycle ... Capturing ctrl keys in form KeyDown - microsoft.public.dotnet ...Hi I am trying to capture Ctrl-C/X/V in a form's KeyDown event and am using the below code but it is not working as pressing Ctrl-C for example r... Navigate to Open a form and Unfilter if prev. Filtered - microsoft ...How to reuse a form? - microsoft.public.access.forms Navigate to Open a form and Unfilter if prev. Filtered - microsoft ... Reuse a form - microsoft.public.access.forms ... Using a browse button - microsoft.public.accessReuse a form - microsoft.public.access.forms Using a browse button - microsoft.public.access Example: A form has a field with a folder path, when clicking on a button the ... Skip used labels in Access 2007 - microsoft.public.access ...IDxCIGNjNTYC&pg=PA159&lpg=PA159&dq=ms+access+vba+skip+label ... How to reuse a form? - microsoft.public.access.forms How do I reuse label sheets when I don't use the whole ... How do I access a sub in a New Class - microsoft.public.excel ...Reuse a form - microsoft.public.access.forms How do I access a sub in a New Class - microsoft.public.excel ... Reuse a form - microsoft.public.access.forms Now however, I ... How do I make a fillable template out of one of my forms ...You could simply save your form as a template, which will let you reuse it over and over again. -- Stefan Blom Microsoft Word MVP (Message posted via NNTP ... Emptying the recycle bin - microsoft.public.windowsxp.general ...How to reuse a form? - microsoft.public.access.forms How do I make the Recycle Bin appear on my desktop in Windows ... Empty the Recycle Bin by right-clicking the Recycle ... Visual Basic - Forms As Reusable Components TutorialsMany developers overlook the fact that forms can make very good reusable components. In addition to the traditional code reuse benefit of reduced development time ... Reusing Forms - Microsoft Corporation: Software, Smartphones ...Greetings I am converting a VB6 program containing multiple forms into a 2005.net VB program. In the old VB6 program I use a modal form and then I want to ... Code reuse - Wikipedia, the free encyclopediaThe general practice of using a prior version of an extant program as a starting point for the next version, is also a form of code reuse. Some so-called code "reuse ... Is it possible to reuse a .NET WinForms Form object? - Stack OverflowOnce a window has been closed, it is possible, and it is recommended, to reuse that window's Form instance to show the same window again? Or is it required or ... Access Blog - Do you reuse expressions, forms and reports?We are looking at ways to make developers more productive in the next release. Tell me about how you create expressions. Do you keep a library of common expressions ... 7/24/2012 5:22:46 AM
|
|
|
|
|
|
|
|
|
Search |
Post Question |
Groups |
Stream |
About |
Register
38 followers. 