[RÉSOLU] Hide record after selection

[menyarito]

http://www.cjoint.com/c/GDwqVouIMI3



can give you access to my computer via TEAMVIEWER so that you can take a look
please

[andy49]

could you download a copy of your database here?

Zip it up then use the Go advanced buttons to download it?

[menyarito]

[QUOTE=andy49;355094]could you download a copy of your database here?

ok,

[andy49]

thanks you

[andy49]

This is great

Would you be able to fill the tables with some false data?

Its throwing up issues otherwise

Thanks

[menyarito]

andy49

It must be like that, it's possible?

http://www.cjoint.com/c/GDwsQhtam13

Thanks

[menyarito]

would you be able to fill the tables with some false data?

yes, of course

[June7]

I disagree with the offered solution. Cross-linking will just cause problems. If house is saved into Clients then don't save client into Houses and vice versa. The combobox RowSource needs to be a query that utilizes both tables.

SELECT Houses.Maison FROM Houses LEFT JOIN Clients ON Houses.Maison = Clients.House WHERE (((Clients.customerID) Is Null));

Then will need code to commit record to table and requery the combobox after house is selected.

Private Sub House_Change()
DoCmd.RunCommand acCmdSaveRecord
Me.House.Requery
End Sub

Private Sub House_GotFocus()
Me.House.Requery
End Sub

Is this db to track ownership? Do you really want each client to have only one house? Can't someone own more than one? Can't more than one person be named as owner for same property (joint ownership)?

Since you are not saving the house ID value into Clients, it is not even needed.

[menyarito]

Hi June 7,

I disagree with the offered solution. Cross-linking will just cause problems. If house is saved into Clients then don't save client into Houses and vice versa. The combobox RowSource needs to be a query that utilizes both tables.

SELECT Houses.Maison FROM Houses LEFT JOIN Clients ON Houses.Maison = Clients.House WHERE (((Clients.customerID) Is Null));

Then will need code to commit record to table and requery the combobox after house is selected.

Private Sub House_Change()
DoCmd.RunCommand acCmdSaveRecord
Me.House.Requery
End Sub

Private Sub House_GotFocus()
Me.House.Requery
End Sub

where add the Code?
You tried this on the database? if oui, please show me the results

Thanks

[menyarito]

Is this db to track ownership?

Yes,

Do you really want each client to have only one house? Can't someone own more than one?

every customer can have many house, the important for me if a house selected after does not appear in the list (see attachment)

Can't more than one person be named as owner for same property (joint ownership)?

No,

[June7]

Post #15 describes how to add code behind a form.

The code I show is for the combobox Change and GotFocus events.

Follow instructions in post #15.

You can also copy/paste the SQL statement into the comboxbox RowSource property.

[menyarito]

June7 ,

http://www.cjoint.com/c/GDxdrK7ymmW
I added everything but it did not work

can you see my db please

Thanks in advance for your help

[June7]

You did not change the combobox RowSource property as instructed.

[menyarito]

You did not change the combobox RowSource property as instructed.

It works

Thanks a lot June7 you're the best