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

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 368
  • Last Modified:

MS ACCESS asset management input form

I am trying to make an asset management database.
What i am exactly trying to do is.... i have several categories of assets.... such a PCs,switches etc....
so i have separate input forms for each category and and i have linked that form's FormID to the AssetID.
Sso i have my FormID as the category which distinguishes between different categories of assets.
So, now i have this form.... which has a combo box for selecting the category....
and depending upon which category is selected i am trying to open the input form for that particular category...........
Here, i am trying to open this input form in a tab control page....
Anyidea how should i be doing this....????
P.S. This is an MS Access database 2003.
0
khushi_crazygirl
Asked:
khushi_crazygirl
1 Solution
 
khushi_crazygirlAuthor Commented:
is there a way to specify the location(like in a specific tab control) where the form should open.......while specifying
DoCmd.OpenForm "formname" command........
0
 
JohnK813Commented:
Docmd.OpenForm has a parameter called OpenArgs, the argument(s) you'd like to use when you open the new form.
In addition, the Value property of a tab control holds a number that represents the tab currently selected, starting with 0 (so, TabCtl1.Value =1 for the second tab, TabCtl0.Value = 2 for the third tab...).

So, if you wanted to open your tabbed form to the third tab, in your main form call:

DoCmd.OpenForm TabbedForm, acNormal, , , , , 2 '2 is the value of "OpenArgs"

and in your tabbed form:

Private Sub Form_Load()
  'only do this if OpenArgs are present
  If Not IsNull(Me.OpenArgs) Then
    TabCtl0.Value = Me.OpenArgs
  End If
End Sub
0

Featured Post

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now