Continuous from's unbound_field to accept individual entries

[Alp Bekisoglu]

Hi Experts,

Sorry for the "subject" if it doesn't make much sense. The issue is:
Need to design a form for pricing selected items and quantities for
companies.
Items in question is in a seperate table with their per item prices.
Structure is: xmlz_id(AutoNum,PK), xmlz_code(Long), xmlz_name(Text),
xmlz_price(Single)

On the continuous form I have all fields plus "quantity"(for entry) and
"total"(calculated: qty*xmlz_price) fields. The form displays the items
properly but the "quantity" field is not accepting individual entries, i.e.
any change reflects on all entries.

How can I get this to work properly? Shall I base the form's data source to
an sql (which is the case now) or a seperate saved query, or the table
itself or to VBA code? Or should I start with an unbound form? Got
confused...

Thanks in advance.

Alp

 

[strive4peace]

Hi Alp,

with an unbound control, there is just one value at a time
for the form -- if you want to have a value on each record,
you need to make it a bound field.

If you are entering quantity for purposes of calculation
only, consider putting quantity in the form header or footer
so it is not misleading when you view the other records.

Have an awesome day

Warm Regards,
Crystal

MVP Microsoft Access
strive4peace2006 at yahoo.com

 

[Alp Bekisoglu]

Hi Crystal,

Tanks for both your reply and an awesome day! I would if I can resolve this.


A bit more on the aim and functioning:
The items consists of 88 materials stored with their code, explanation and
price in tb_xmlz.
I need to create a form that will display all these items (preferably on a
single form) where user will enter the requested quantities of the requested
items (not all will be requested).
Another field is to calculate each requested item price total
(quantity*xmlz_price).
Then the item code & quantity for the selected items will be stored in a
seperate table(xmlz_requests) together with the company ID.
Grand total of these will be stored in yet another table (transactions) as
debit for the requesting company.
I thought of continuous forms, 4 of them actually, to fit all on a single
form as sub-forms.
Reason behind the unbound main form is to keep the data until it is
confirmed for storing. An sql of one of the subforms is:
SELECT tb_xmlz.xmlz_id, tb_xmlz.xmlz_kodu, tb_xmlz.xmlz_adi, [adet] AS
Expr1, tb_xmlz.xmlz_fiyati, [tutar] AS Expr2 FROM tb_xmlz GROUP BY
tb_xmlz.xmlz_id, tb_xmlz.xmlz_kodu, tb_xmlz.xmlz_adi, [adet],
tb_xmlz.xmlz_fiyati, [tutar] HAVING (((tb_xmlz.xmlz_id)<23));
Initially I opted to divide the 88 into 4 sets via the HAVING. Next one
reads HAVING (((tb_xmlz.xmlz_id) Between 23 And 44)) and so on.
Just couldn't focus on how I could solve this.

Any help, ideas would be highly appreciated.

Thanks again and whish you a great day.

Sincerely,

Alp