Thanks Clive for examining the file. The main form displays the taxpayer info; i.e. Name, DBA Name, street addr, mailing addr. The first subform (in the tab sequence) called frmLicense using data from the tblLicense. Most taxpayers will have at least 2 tax numbers; one for the city (strCityLicenseNum) and state (strStateLicenseNum). At time there maybe multiple numbers (due to company doing multiple activities; i.e. contractor being issued a different license for each job. Therefore, multiple records for a taxpayer may exit in the tblLicense table. What I am trying to do is display the license numbers of the current record on the main form so the user can see the tax numbers when examining other subforms in the tabbes sequence. If the user selects an property for example the associated tax numbers would appear on the main form.
I may be reaching to get the display to work as described. There may need to be more relationships between some of the forms.
This weekend, I plan on trying the suggestion of the variable being pasted to the unbound fields.
Again thank for any suggestions.
Rod
--- In MS_Access_Professionals@yahoogroups.com, "Clive" <zctek@...> wrote:
>
> 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