Form Auto population

[Evgeny]

i guys,
Im completly new to Access and have been asked to build a database which includes, three main tables customers, buildings and asset register for each building. As you can see from Customer Form, i created a button called Asset Register, which brings up Asset Form based on Macro <OpenForm = Asset, Datasheet, , , , Normal; ApplyFilter = [Asset]![Building ID]=[Forms]![Customer]![Building].[Form]![txt_BuildingID].[Value], >. (Not too sure if its right way, but it works).
The problem is when i open up Asset Register Form - i can input all the information and it will be saved in Asset Register Table, but i have to input Building ID manuly for the same building, and i have about 300 items ;(. How do i automate this proccess, so building ID populates automaitcly for all items when i enter information (and saves it in Asset Register Table)?
Please inform me if i made very stupid mistakes in my database, any critisism will be appreciated, i am trying to learn Access

[pbaldy]

Duplicate thread:

https://www.accessforums.net/forms/f...tion-5228.html

[Evgeny]

Yeah, sorry, net went down, couldnt figure out whether the first one was posted or not. Appologies

[pbaldy]

Not a problem; I noticed the other one had the attachment, so I figured something went haywire. Just didn't want to get responses split up in 2 different threads.