Solved Edit or create, problem with my drop-down lists (1 Viewer)

[Superpat]

Hello, Despite the help of arnelgp, I still have just as much problem with dropdowns (not the ones where it occurred).
I would like to modify a record in the f_CurrentNouveau form, but that the t_Categorie and t_SubCat tables are not modified (just to draw).
I would like to create a record of the form f_CurrentNouveau, but that the tables t_Categorie and t_SubCat are not modified (just to draw).
So each time the t_Courant table is impacted.
Thank you for your help.

 

[jdraw]

I do not understand your request.

What do you want to modify? ...modify a record in the f_CurrentNouveau form, but that the t_Categorie and t_SubCat tables are not modified (just to draw).

Some sample data showing a change in the record would be helpful..

 

[Superpat]

I do not understand your request.


Some sample data showing a change in the record would be helpful..

 

[Superpat]

Hello jdraw
When I want to change the category I have the message :

Maybe we have to break the links ?
Then, I want the link to take place and the subcategory to appear with the corresponding links (see f_SousCat)

Here, nothing appears !
And that the modification is only in the table t_Courant

 

[MajP]

you need to compile and debug. You have a TON of undeclared variables. This thing will not compile as is.

 

[Gasman]

This is what you get if you try and change even in the query

 

[Superpat]

There was an error in the "f_Courant" form.
I modify the queries, indeed I had changed a table name and this name did not follow in all the queries.
I compact and repair.
I reposted the new file.
Thank you for your remark.

 

[Gasman]

Same error, although you can now change the category

 

[Superpat]

I'm looking tomorrow, thank you and have a good New Year's Eve.

 

[arnelgp]

check out this one.

 

[Superpat]

Thanks Aenelgp for your help, again it was perfect and exactly what I wanted.
Happy New Year to you

 

[arnelgp]

HAPPY NEW YEAR!