Creating a form for checkout q3 (college project)

[h3llz]

If i set up two fields one is text, and the other combo. Then i use a button
to get information about that product (only need to use one field), it would
add text about that product in the same form on a different section, is that
possible?

 

[banem2]

If i set up two fields one is text, and the other combo. Then i use a button
to get information about that product (only need to use one field), it would
add text about that product in the same form on a different section, is that
possible?

Hi,

If I understand, you are having trouble transferring product name from
combo-box to text-box? Assuming that combo box has record source like:

RowSource: SELECT ProductID, ProductName FROM tblProducts
ColumnCount: 2
ColumnWidths: 0", 1"

You can copy ProductName to text box using:

txtBoxName = cmbComboBoxName.Column(1)

(column count starts from 0)

Regards,
Branislav Mihaljev
Microsoft Access MVP

 

[h3llz]

I can design/structure tables/relationships/queries good because i've got
alot experience in php/mysql but using forms to work with the table structure
etc i cannot do without difficulty, when i open the form i will have a
product ID field and product Name field, i can use either of them (the
product name will be combo box which i dont know how to set within a form)
then i use the button and additional information of that product if theres a
match will appear on the same form with a add to cart button, if i click that
then it adds it to the cart, and then i will have a checkout button witch
will execute a query for each product to change the quantity of that product
and then generate a report ready to be printed (invoice). Also next to the
add to cart button there would be a field to select the quantity.

 

[Cheese_whiz]

Hi h3,

Combo boxes in access often (usually) have select queries as the basis of
their rows. So, though you may only see a single value per row when you USE
a combo box, 'behind the scenes' each choice is one column in a multi-column
record. Combo boxes allow users to choose a value from the column whose
values they understand (product NAME), while allowing access to use the
matching hidden column values that it needs to function, and function
efficiently.

Check out this link:
http://www.databasedev.co.uk/ms_access_combo_box.html

CW

 

[Steve Sanford]

Also, be sure you understand the difference between "Lookup Fields" (defined
in the the table) and "Combo boxes" (controls on a form).

Lookup fields (defined in the the table) are EVIL..... they will cause you
problems. See:

http://mvps.org/access/lookupfields.htm


Or Google "evils of lookup fields"


(Here are other good "rules" to follow:

http://mvps.org/access/tencommandments.htm)

HTH

 

[h3llz]

i think you dont understand what the requirments are, one form to control
multiple tables, one side will have a text field to enter a product ID, or a
combo box which have all product names, but the default selection is null.
When you submit the form on the other side of the form will be all that
product additional information, then a text field to enter a quantity and a
add to cart. Would have a cart at e.g. bottom left of the form, which if you
fill the box up it will scroll (like a frame in html) and you can remove a
product from the cart, have text which calculates all the prices together.
then it have a checkout button when you press it it will generate a report of
the cart etc.