Solved Edit or create, problem with my drop-down lists

Superpat

Member
Local time
Today, 08:59
Joined
Aug 15, 2020
Messages
121
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.
 

Attachments

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..
 
Hello jdraw
When I want to change the category I have the message :
Courant1.jpg



Courant2.jpg

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)
Courant3.jpg

Here, nothing appears !
And that the modification is only in the table t_Courant
 
you need to compile and debug. You have a TON of undeclared variables. This thing will not compile as is.
 
This is what you get if you try and change even in the query
1609430429870.png
 
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.
 

Attachments

Same error, although you can now change the category
 
I'm looking tomorrow, thank you and have a good New Year's Eve.
 
Thanks Aenelgp for your help, again it was perfect and exactly what I wanted.
Happy New Year to you 🙂
 
HAPPY NEW YEAR!
 

Users who are viewing this thread

Back
Top Bottom