Auto-update listbox on form

hi jack

   i always have a popup asking me, enter value of  catogory :(. then for the update i need to enter category again with integer :(

  thanks

and it update all entry :( not only the one i edit

This routine should be consolidated to have the control that holds the [forms]![FormName].[category] on the form that has the list boxes.
Perhaps a combo box (unbound) with a rowsource of all the valid [category]'s

Advantages:
  1.  1 fewer form to maintain
  2.  Integration of the filter control with the form being filtered.
  3.  Tighter scope of operation.

the row source of [forms]![FormName].[category] is :

SELECT category.id, category.Category FROM category;

then it list all cat in the DB, it when i choose one cat, i want it to update the visitor and recevor fields, it do it, but for all entry..., i already did it, 4 years ago, but i dont remember how ( and i lost DB... :(  )

in regard
popy

1.  It seems to me that Category.id would be the key field here.
   (This field name should be CategoryID, not just ID.  "ID" is non-descriptive when viewed alone.

2.  It is bad juju to have a table and a field IN that table named the same.

3.  Set the rowsource sql to include a reference to the cboCategory
in lstVisitor
  SELECT * FROM Visitor WHERE ([CategoryID]=[forms]![FormName].[cboCategoryID]);
  'cboCategoryID = "cbo" for combobox + CategoryID, the field name I suggested you change

and lstRecevor
  SELECT * FROM tblRecevors WHERE ([CategoryID]=[forms]![FormName].[cboCategoryID]);

(prefixes added to form controls are my suggestion...)

All of your suggestion working... but on the records, the fields visitor and recever are changing too... thats is cause problems

in regard
popy

According to the way your question was worded I thought this was the desired behaviour.

yes, but not on the other record, only the one i edit,

i made a continue form, so then i edit record no 8,  want the fields visitor on record 8 to change, not the record 1,2,3,4,5,..etc...

  maybe i didnt explain well... but now you understand what i mean..?

 in regard
popy

let me guess,... you are using an unbound listbox control on a continuous subform...

yep

oups,... no i dont have subform

but we are still talking continuous form.

yes

on any continuous form what changes a control in affects all the copies of that control going down that column.

I believe you might need to reconsider your plan of action for this form.

Are these controls listboxes or comboboxes, there is a distinct difference.

ok thanks for your answers....and work.... there is your point :)

you're very welcome!

have you reconsidered how you want to accomplish this, or what behaviour would work well to efficiently get data into your system?

no problem

well, i made another form, this one not continuous, my user, (the one who made schedul for baseball) will work with it.... i liked continuous form because you can see all games in one shot