Add button for subquery (subform)

[D347HxD]

Hello! This is my first post here, and I hope I am posting this in the right area of the forums, if not please direct me in the right direction.


I am building a database, that includes a subform (which is a query) and a bunch of text boxes that let you search the query. With these text boxes I'd also like to be able to add records on the table the query collects the data from. As in, you type into the text boxes above the data needed, then push the big red add button and it'd add a record with all the information you just included into the database; and you can see it below and search for it etc. I've looked around and found no help, so I'm crossing my fingers you guys can help!

My database: below

Thanks in advance!

 

[jdraw]

See the STICKY at the top of Queries forum and see if that helps.
http://www.access-programmers.co.uk/forums/showthread.php?t=212124

 

[D347HxD]

Thank you! Post updated.

 

[jdraw]

I'm going to recommend a couple of things based on a quick look at your database.
Since there are no relationships (referential integrity), I suggest you work through this tutorial to get a better handle on database design.
http://www.rogersaccesslibrary.com/Tutorials/Entity_Relationship.zip

Also, I am recommending you watch some videos concerning Customers, Orders and Items. These videos are suited to your situation in my view.

See this link from a previous post
http://www.access-programmers.co.uk/forums/showthread.php?t=238668#4

Good luck with your project.

 

[D347HxD]

Well, if you are talking about CustmerT : OrderT, CustomerT is actually 100% unneeded and was just me fooling around in my spare time. OrderT is only table I need at this point.

 

[jdraw]

OrderT is only table I need at this point.

That's a little bit like designing a house, but working with physical artifacts---
... all I need at the moment is a window frame....

You will find designing a database much easier if you work from some logical/conceptual design -- similar to artist's concept of a house to be built. You can build the pieces sequentially in any order you want, knowing where they fit in the big picture.

Good luck with your project.