Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

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
0
Davidobud
Asked:
Davidobud
  • 3
  • 2
1 Solution
 
DavidobudAuthor Commented:
I find the solution,
That was à property in the serch form.....

Sorry
0
 
raidxpCommented:
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
0
 
raidxpCommented:
see this notes :

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

then talk to me again ->
 
raidxp
0
 
DavidobudAuthor Commented:
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
0
 
DavidobudAuthor Commented:
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, for your help, Davidobud
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now