Search results

Wow - very detailed information - thank you so much for that! Totally appreciate the effort. It works and was easy to follow and implement! I need to know... because I can really use this elsewhere as well. How does this work? Is this like a query that only exists in an event procedure...

How should those two tables tblunit and tbltenant related? Is it tenantID = UnitNum? NO They are not joined per say. tblOccupancy is joined to tblTenant and the UnitNum should be taken from tblOccupancy. Make sense? Can you still assist me? Thank you.

Here is a reduced sample of the database. You should open the frmUnitUpd first to see... The combo box is the one in the subform frmUnitUpd_Deposit and is called TransactionTo. Ideally, I would like it to show UC ([LastName] &" " & [FirstName] but insert and record the TenantID. I did not...

Very sorry. Yes, I did open/close... Guess would be better to provide a sample. Thank you!

Tried the first codes suggested, in OnEnter - getting nothing, still blank with no error message. The field UnitNum is a number field + a primary key. It is on the Main Form. It comes from tblOccupancy. Tried the second suggestion - same results.

Thank Boerbende. I added these codes hopefully as per your instructions. Private Sub cboTransactionTo_Click() Me.RecordSource = " select [LastName] from tblTenant where UnitNum = " & Me.Parent!UnitNum End Sub It didn't do anything - was still seeing the entire list of tenants. So removed...

Hi everyone! I have a form called – UnitUpd. It has two subforms – let’s say A and B I open the form to a specific Unit, let's say Unit 1. Subform A – lists the tenant living in that Unit with contact info, etc. Subform B – among other things, has a combo box where the user selects the...

Got you! You are right, it doesn't answer all my questions but I will experiment with it. I will then keep the PositionRptFooter module. Again, thank you!

This is terrific! Works perfectly. Thank you so much. Did you also see my questions regarding the report that you helped me with? The group footer thing...

Hi everyone! I have a continuous subform where users will enter tenant's names along with their Status. The status is selected through a limit-to-list combo box offering a choice of M, O or F. I need to ensure that ONE of the tenants has the status F and no other tenants have it. Other...

Answers to the above questions, anyone? Thank you!

Wow! Thank you Arnel. Works great. I just have some questions. Please keep in mind I am sort of a newbie... The function is causing the problem. it is making many pass to the report ensuring that it will fit in 8.5 paper. Ok that I understand. before i made the changes i copy your...

No the problem was not that is was in there twice as I tested it after I removed the extra one, in there by mistake. I will open Arnel's file - thank you!

Oups! The codes should not be there twice. Just for the Page Footer. Deleted the other (thank you). However, I does need to be there - it forces the footer to be at 8.5. Is that a problem?

Here is the sample. The form to open is frmUnitUpd. There is only one report. Don't know that this is relevant to this issue but the report only views properly in Print Preview, not Report View. It will still show up in Report View but the page break is ignored. Thank you Gina for all your...

So am I. Will provide a copy of the DB. THANk YOU

On the Main form

Yes, it is a Main Form, Sub Form scenario. But the UnitNum field is in the Main form.

I don't see where you have a Control on the Form showing the UnitNum, I only see it in the JOIN. Unless are you pulling it from tblOccupancy? Yes, as I said, both the Report and the Form pull the UnitNum field from the tblOccupancy. Ans if you are please confirm that the name of the Control on...

Report SQL SELECT tblOccupancy.UnitNum, tblTenant.* FROM tblTenant INNER JOIN tblOccupancy ON tblTenant.TenantID = tblOccupancy.TenantID; Form SQL SELECT tblOccupancy.*, tblUnit.UnitType, tblTenant.FirstName, tblTenant.LastName, tblTenant.Gender, tblTenant.DOB, tblTenant.Status...