temporary table of SOME records (1 Viewer)
- Thread starter Nastaran
- Start date
- Local time
- Today, 01:51
- Joined
- Oct 29, 2018
- Messages
- 21,454
Hi. What do you mean by selecting records from a form? How exactly would you select each one? If you want to select records from a table, you can use a query with a criteria. You can then convert this select query into a make-table query.
- Local time
- Today, 01:51
- Joined
- Oct 29, 2018
- Messages
- 21,454
Hi. You don't add records to a form. You add them to a table. To add records to a table, you can use an APPEND query. So, in your "Add to Cart" button, you could execute the APPEND query.
bastanu
AWF VIP
- Local time
- Today, 01:51
- Joined
- Apr 13, 2010
- Messages
- 1,402
Usually you do that by having a boolean field in the table named IsSelected or something similar then you use that ([IsSelected]=True) in a query used to populate your cart, This allows for multiple selection as well.
Cheers,
Vlad
Cheers,
Vlad
Hi
my form is result of another query and table and I want to select one of this result and add it to my "add cart", I know that this result should save to another table, but I don't know How, and Unfortunately I don't know How can I use append query.
tnx
my form is result of another query and table and I want to select one of this result and add it to my "add cart", I know that this result should save to another table, but I don't know How, and Unfortunately I don't know How can I use append query.
tnx
- Local time
- Today, 01:51
- Joined
- Oct 29, 2018
- Messages
- 21,454
Hi. See if this article helps.
