asked on

Cannot update recordset in a subform

I build a DB with different frames
I 've got a main form. In that form are two subforms, called menu and content.
I show the subforms selected by the menu on subform content...
It works properly using that way
I make an independant search form, called from the menu, as to easily find a record.
When I select the record and ask to show it in a modify forms it works.
The modify form appears in the the frame content, the search forms is then closed.
The modify form is based on a query who select the record using [Numéro] who is the id of the record.
But I cant modify the record who appears in my form.
The state bar told me its impossible to modify the record.
There are no groupments im my query
I verify All the propertys of the form but it wont work.
Can you help me please !!!! Thanks

Davidobud

ASKER

I find the solution,
That was à property in the serch form.....

Sorry

raidxp

1> you have to build master key (in the main table )and aforgin keys in the other tables.

2> make relationships between tables correctly ...logically!

3> be carfull some query's result are un updateable... can not add recoreds to the underlinig tables,but you can update current recoreds values

ASKER CERTIFIED SOLUTION

raidxp

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Davidobud

ASKER

All that you said to me was done...

I 've find what my problem was:
I had putted a global recordlocks in the search form.

I was launching my modify form from this one and it
was locking the childs forms too.....

Thanks, Davidobud

Davidobud

ASKER