saving searched items on form

[knaya]

I am beyound confusion right now and i really need ya'lls help.. heres the problem.. i have a from where i am able to search for products..
1. when i enter the prodid and hit the search button, the prodname, price etc comes up..
2. now i have another button that when i hit, i woud like for it to save the produc name, price etc into a new set of textboxes so i can search for another product and continue adding based on the number of products the customer wants to buy
3.then finally, when i hit a check out button, i would like the saved items to update the status in the prod table and send the respective fields to another form where i can now enter the customers info and finish the selling process..

The only part i am able to get working is on the first search, i can save the values to a row of fields i have defined but when i do another search and i try saving it to the next set of rows, it saves intead in the first thus cancelling out the first saved items... Does anyone please know how to get this working correctly????? Muchos Graciousssssssssss

 

[mph1]

What you are attempting to do can be done. IMO, there is no easy solution and will require coding along with a temporary table to hold the information. When you finish, the table will have to be emptied.

You could use a continious sub form that would keep track of the items you search.

I know I haven't given you a specific answer, but I don't think there is one. Also, it will depend on how you currently have your database set up and you knowledge of coding.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[knaya]

so i've spent 4 days on what i thought i'd spend 4 hours..so much for thinking i know access like that..okay, i've kinda changed how i want to to work, i have a product table thats stores id, name etc. now when i find a product and these details come up, i want to click on a button and save these detailes to another table (not product table).. how can i do this.. God knows when i get some money i'm going to go get "access" for dummies..:-0

Mph1, i'm going with your idea i just dont know how to store the details on another table(dumptable)..helppppp

 

[mph1]

God knows when i get some money i'm going to go get "access" for dummies..

This is one source and there are also many other good books. There are also many places on the internet that offer free information etc - the following is only one of them.

http://www.mvps.org/access

Conceptually, your are looking at something like an invoice that has multiple entries. Have you looked at the sample "Northwinds" that comes with Access??

If you use the subform idea, you can have the subform off the TEMP table and the main form off the table/query you currently have.

If this is your first real attempt at using a database, you picked a tough one to start with.

Please don't misunderstand my comments -- I am not making fun of you or what you are attempting to do. Keep in mind, even to create a simple database (from scratch) by someone experienced, will take several hours.

I only hope that I have been able to give you some food for thought. You must learn to crawl before you can walk.

An investment in knowledge always pays the best dividends.
by Benjamin Franklin

 

[knaya]

mph1,
i really want to give up on this database but i really believe i can do it.. i didnt get any info from the website pertaining to my problem (but i got some other good info.. thanks).. all i want to do is add fields on a form to another table????? I'm dieing here and for some reason i cant access the northwind example (i already tried