Recent content by omontesg

Yes, You are right. Thanks for your time and explanation. O.Montes

Thanks Bob, thanks ChrisO for your prompt anwers. Both ways (Bob's and mine) worked OK. my problem was a name in a form. (that's the bad thing of Cut+Paste). I am addressing the forms from the top one. Any way, ChrisO, I am interested in knowing the difference between the two ways You...

Hi everyone, Does anybody knows how to address a Fifth level Form? Up to the fourth level, for me worked the following statement: Forms!frmClass!frmGroup!frmAccount!frmSubAccount!frmAuxiliar.Form.Name ...But if a I insert a new form and want to address that one deeper level Form; ACCESS...

There is not option. I must show ALWAYS the PopUp ChildForm because: 1-It makes sure the user to know there are or there are no Child Records 2-I use this ChildForm for the user to Add/Edit ChildRecords. It works his duty But I hate ( and surely my users will too ) the famous Access Message...

Sure I made PK->FK Relationship (field FatherCode), that is why I can see the child records when they exist. Thanks for your interest

Good afternoon ; I have 2 tables: FatherTable and ChildTable. related by a field one to many. Records in FatherTable may or may not have child records in ChildTable. (That is possible and logical isn' it?) I Have the Father data shown in a Form "FatherForm". I Have the Child Data shown in a...

Thanks Paul.

Hi Paul, Thanks for your help. Searching for "Cascading combos" I found you have answered very similar questions to many people... So something is missing on MS Access documentation (or at least is not so evident). Thanks for your patience. Surely it works on Forms, but let me insist on...

Hi Ajetrumpet, Sorry I see no redundancy on Jame's database structure, could you show me where is it?

Hello every body; I have a 3 tables: 1-CountriesDBF(Field: CountryName) 2-CitiesDBF(Fields: CountryName(with search Property = Countries.CountryName), CityName) Linked by CountryName with Countries 3-CitizensDBF(Fields: CountryName, CityName, CitizenName) I want the following:as soon as the...