A
Andrea L
Hello,
I'm hoping somene can help me and that I describe this well. Here is my
situation:
I have a form that is used to collect information for setting up new
customer accounts. In the form I have 3 views: customer information, initial
order, and a print view. This form is linked to an Access DB.
The customer info view is a series of text, drop-down, and check box fields
that the user uses to select information and enter information about the
customer. On the order view there is a repeating table to enter sku, qty, &
price info that gets calculated and added to a total field. The print view is
just a nice view showing all the entered info so someone can print a nice
copy of need be.
This all works great when you create a new record, you can move back & forth
through screens,etc. However, the problem comes in when I need to query a
record to make changes. I need to do two different things with queries -
first I need to be able to query an existing record to make changes to that
record and secondly, I need to be able to query for a record using wild cards.
When I query a record now, the customer info view comes up and allows me to
make changes. However, when I switch over to the order view, the repeating
table doesn't allow me to insert a new row to add order items. If, lets say
there already were some items on the order and I needed to add more, it
doesn't show me the existing rows either. Is there some way to make that
work?
As for the wild cards - I have no clue how to even make that happen. So if
anyone can help me there I would be very appreciative.
I'm hoping somene can help me and that I describe this well. Here is my
situation:
I have a form that is used to collect information for setting up new
customer accounts. In the form I have 3 views: customer information, initial
order, and a print view. This form is linked to an Access DB.
The customer info view is a series of text, drop-down, and check box fields
that the user uses to select information and enter information about the
customer. On the order view there is a repeating table to enter sku, qty, &
price info that gets calculated and added to a total field. The print view is
just a nice view showing all the entered info so someone can print a nice
copy of need be.
This all works great when you create a new record, you can move back & forth
through screens,etc. However, the problem comes in when I need to query a
record to make changes. I need to do two different things with queries -
first I need to be able to query an existing record to make changes to that
record and secondly, I need to be able to query for a record using wild cards.
When I query a record now, the customer info view comes up and allows me to
make changes. However, when I switch over to the order view, the repeating
table doesn't allow me to insert a new row to add order items. If, lets say
there already were some items on the order and I needed to add more, it
doesn't show me the existing rows either. Is there some way to make that
work?
As for the wild cards - I have no clue how to even make that happen. So if
anyone can help me there I would be very appreciative.