update existing data on table through form

[luzz]

Hi there, how can i update data that is saved on the table through form?

Currently, i have a form modify, and a listbox that is created by using data from the table. So let say i want to modify on one of the PO number that already exist in the table, by retrieving the data to the form and after i am done with the modification, i clicked saved, the table should only save the latest record

 

[Minty]

Simply bind the form to the table for editing.
You know that you are working on the live data, and that anyone else can't edit the same record, whilst you are using it.

 

[luzz]

Thank you both for the help, i have created a bound form and it works! But how can i use search for keyword on a bound form? i am able to search keyword on my unbound form

 

[Minty]

Create an unbound control on the form and either filter the records as Pat suggested, or requery to only bring in the records you need.

On large recordsets the best method is to load the form with an "empty" recordset, Something like where PrimaryID=0 then load a specific recordset based on the forms search criteria.

An excellent example of this would be here http://allenbrowne.com/ser-62.html - this uses a continuous form, but can equally be applied to a single form with more controls and the use of record selectors.

 

[luzz]

I mostly work with SQL Server databases so I never use filters but if the BE is Jet or ACE and the table isn't too large, you can use filters to do this.

Did you make the combo using the wizard as I suggested?

Hi, yes i use two combo box, one for PO the other for colour. I have no issue having the values in the combo box. However, when i select PO 1 and colour blue, it will jump to record blue but the PO is 2.

How can i make the record to jump to the value that i selected based on the two combo box?

 

[Minty]

How have you set up the filter from the combo's?

 

[luzz]

How have you set up the filter from the combo's?

i did not use any filter

 

[Minty]

So what is happening when you change the combo value ? I'm confused.
Is this a unbound combo?

 

[luzz]

So what is happening when you change the combo value ? I'm confused.
Is this a unbound combo?

Oh, when i click on the value 1 in the PO combo box, it will filter the PO 1
It is not a unbound combo

 

[Minty]

If it is bound then you would be changing the underlying data, not filtering!

To make a filter based on the combo it must be unbound - normally you would put it in the header of the form.

You would then use some VBA to perform the filtering. Did you look at the example on Allen Browne's site?