Hi Rod,
Thanks for the UpLoad. It will take me a while to get
to know it. I don't much like the Access .XPS version
of Relationships. It's a iserable jb trying to edit
them. For smaller DBs I prefer to copy the
Relationship's screen view and paste it into Word.
"The info on all the subforms update to the proper taxpayer
but I can't seem to display information from the license
numbers from the subform to the mainform."
Is there just a single licence for each Taxpayer or
do you want to display more than one on the main form?
You can reference items on subforms from the Main Form
if that's what you want, and display it in an unbound
label or Textbox.
On second thoughts, you will need to push it from the
subform if you have more than one record on the subform,
since the On_Current in the MainForm will not happen
when you cycle through the subform. Something like,
Private Sub Form_Current()
' Update MainForm Unbound Control (if it is open)
Dim strFullname As String
strFullname = Me.Controls("Name").value & " " & _
Me.Controls("SurName").value
Me.Parent.Form.Controls("txtFullName") = strFullname
End Sub
Regards, Clive.
--- In MS_Access_Professionals@yahoogroups.com, "rodbevill" <desertscroller@...> wrote:
>
> Hi Clive,
> I uploaded a file in the need assistance folder.
> Description:
> Relationship chart for Tax Audit - Rod
> It is in XPS extension. Was not sure of the way to get it for viewing without the whole file. Thanks for your time and any suggestions would be appreciated.
> The main form uses the tblTaxPayerInfo table.
>
> Thanks again
> Rod
>
> --- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@> wrote:
> >
> > Hi Rod,
> >
> > If/When you have your tables and relationships defined,
> > could you upload your Relationship diagram?
> >
> > Then we will be able to give you more help.
> >
> > Regards, Clive.
> >
> > --- In MS_Access_Professionals@yahoogroups.com, "rodbevill" <desertscroller@> wrote:
> > >
> > > I am developing an auditing database for tracking properties,communications, state and city licenses, and a couple of other forms. Each form is associated as a subform in a tabbed structure on the main form. The issue I am having is displaying information from the tabbed forms on the main form. The main form shows the tax payer, addresses and audit type. Some of the information is contained in one or more to the subforms. I would like the information on the main form to update with the information from the subforms as the main form navigation buttons are selected.
> > >
> > > The info on all the subforms update to the proper tax payer but I can't seem to display information from the license numbers from the subform to the mainform. This is desirable so when the license tab is not active the informtion will be display (Note: there other information on the license which will only be displayed when the tab is active.
> > >
> > > Hope this is not too confusing.
> > > Rod
> > >
> >
>
Tidak ada komentar:
Posting Komentar