Form doesn´t update with Query.

[disturbedgod]

Hi All… how are you doing?




I´m new to this site, and I’m not very good at Access. J

So, if you could help me with a problem that I have about my database, that would be great.


Here it goes…


My database is about a Construction Company. I have SubContractors info that are Organized by the work they do (Concrete, Iron, FormWork… etc).

So, I have a Form (frmCustomers), that as a SubForm (frmMultiselect) in it.

In the Form, i have One Combobox (cboSelected), that gives the user the ability to see and choose all of the Works that i have in the Database, and one ListBox (lista9) that when the user chooses the Work in the Combobox, a list of Companies that make that work appears, and the user gets to choose the company that he wants to see the details, by selecting the company and by clicking on a button (comando15). The button creats in a query (qryMultiselect) the information about that company.


In the SubForm, that´s inside the Form, i have fields that shows the data from the Company that the users selected in the Listbox (lista9).


The Problem here, is that the SubForm only updates the information about the Company that the user selected when i Close the Form and then Open it again. I want that when the user presses the button (comando15) the information in the form updates automatically.
In the button (comando15), i´ve tried to creat a code that Requerys the Subform. But it doesn´t work.


Sorry about the English… hope you guys understand the problem.

[llkhoutx]

I suspect that your subform is not properly linked to your form. Verify the subform's Master Link and Child Link properties.

[RuralGuy]

DoCmd.RunCommand acCmdSaveRecord will save the current record.

[disturbedgod]

I suspect that your subform is not properly linked to your form. Verify the subform's Master Link and Child Link properties.

How can i see this?
I´ve made the SubForm (frmMultiselect) inside the Form with the draw comand "Subform/Subreport"

DoCmd.RunCommand acCmdSaveRecord will save the current record.

This doesn´t seem to work. Where should i put it? In the end of the code of the button?!

Thank you.

[RuralGuy]

This doesn´t seem to work. Where should i put it? In the end of the code of the button?!

Thank you.

It should be the *FIRST* line of code behind your button.

[disturbedgod]

It still doesn´t work RuralGuy...

Do you think i can post the database here and you can see what the problem is?

Thank You
Hugo

[RuralGuy]

Go ahead and post your db. Someone here will probably look at it and come up with a solution. Be sure and first Compact and Repair the db and then zip it up before posting.

[disturbedgod]

Ok... i´ve done all that you have asked...

Hopefully someone will find out the problem.

Thank You.
Hugo

[disturbedgod]

Can´t nobody help?! :S

Thank you
Hugo

[thhui]

Could you convert it to mdb 2000 format first and zip it and upload it again?

[disturbedgod]

Could you convert it to mdb 2000 format first and zip it and upload it again?

Thank you thhui, but i have already found a way to do what i wanted. I´ve created a button that on the second click the Form (frmMultiselect) opens separated from the main one, and the info is updated.

Thank you again to all.
Hugo Bastos