?
Solved

Cannot update recordset in a subform

Posted on 2003-03-05
5
Medium Priority
?
216 Views
Last Modified: 2008-03-10
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
Comment
Question by:Davidobud
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 1

Author Comment

by:Davidobud
ID: 8070367
I find the solution,
That was à property in the serch form.....

Sorry
0
 

Expert Comment

by:raidxp
ID: 8070403
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
 

Accepted Solution

by:
raidxp earned 360 total points
ID: 8070409
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
 
LVL 1

Author Comment

by:Davidobud
ID: 8071828
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
 
LVL 1

Author Comment

by:Davidobud
ID: 8420528
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

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Windows Phone Theme Colours is a tight, powerful, and well balanced palette. This tiny Access application makes it a snap to select and pick a value. And it doubles as an intro to implementing WithEvents, one of Access' hidden gems.
This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Show developers how to use a criteria form to limit the data that appears on an Access report. It is a common requirement that users can specify the criteria for a report at runtime. The easiest way to accomplish this is using a criteria form that a…
Visualize your data even better in Access queries. Given a date and a value, this lesson shows how to compare that value with the previous value, calculate the difference, and display a circle if the value is the same, an up triangle if it increased…
Suggested Courses

800 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question