Auto populate

[Adrianne]

I am new to Access and can't seem to figure out how to do
something. I have a form built that has command buttons
to other forms. sort of like a switchboard. When you
click on a button, it opens another form that also has
command buttons to other forms. Well, this is for
inventory control. so, when you click on PC Inventory,
it opens the form to enter the inventory information.
There is also a command button to add additional
information if needed for this one item. How can I get a
particular field to auto populate on this imbedded form?
I enter the Asset # on the front screen. I click on this
command button to add more info on this particular asset
and I want the Asset # to carry over for me. Is this
possible?

 

[Guest]

I also have a Help Desk database that doubles as an inventory database. My
table has, to name a few, UserName, IPAddress, SerialNumber, MachineName,
LastPM, SoftwareInstalled, CPU, Memory, etc. What I do is create generic
form, your "imbeded", with all of the data from the table that I want to see.
Next I create a query based on whatever item I want to search for, in your
case "Asset #". Third I create a form with a combo box that is based on that
query. When you hit the drop down arrow, it lists all of your assets. Forth
and final, I create a button next to the combo box, to open the form I
created in step one. Durning the creation of the button, one of the options
is to "Open the Form and find Specific Data to Display" select that one. On
the next screen, select the Combo box name from the left column and on the
right column select the equivelent name from your table, then hit the <->
between the columns. Finish creating the button. When you click on the
button it will open the new form and populated it with what info is available
in the table. The real slick part of this whole operation is, you can create
multiple queries and multiple combo boxes, for different criteria, on that
same form. The only difference is equivelent name selection when you are
creating a new button for the new combo box. By the way, if this is a new
asset, you can create a simple button on the same page that says "New Asset".
Have it open the same generic form and just fill in the blanks. Hope this
helps. Bim