Design Question

[dsomers]

Hello all, I have a design question concerning my real estate program. I want to be able to click on button on my utilities form and have it open a form that lists all the tenants with an active lease. From there I want to be able to select tenants that I want to post rent to and be able to hit a button and have it post their monthly rental rate to the ones I select. Here is what I want it to display:

Select (checkbox)
Tenant First Name
Tenant Last Name
Building Number
Apartment Number
Amount of Rent to post (default to their monthly rental rate)

I am not sure how to go about implementing this. My first impression is to use a form with subform in datasheet view. Can someone give me some advice on how to implement this or point me to an example that demonstrates something like this?

Thanks!
David Somers

 

[dsomers]

Thanks! I tried to download version 3 from that link and Winzip says the archive is part of a spanned set. I downloaded version 2 and the listbox is similar to what I want, but I would rather have a checkbox rather than highlighting the selected entries.

Is this possible?

Thanks!
David Somers

 

[dsomers]

Well, I've got something almost working. However, I used a query to create a temporary table. Here's the VB code for what I'm doing when I open the form:

Private Sub cmdPost_Click()
On Error GoTo Err_cmdPost_Click

    Dim stDocName As String
    Dim stLinkCriteria As String

    DoCmd.OpenQuery "PostRentQuery", acViewNormal

    stDocName = "frmPostRent"
    DoCmd.OpenForm stDocName, , , stLinkCriteria

Exit_cmdPost_Click:
    Exit Sub

Err_cmdPost_Click:
    MsgBox Err.Description
    Resume Exit_cmdPost_Click
    
End Sub

Is there a way to prevent Access from displaying the warning messages about overwriting data and adding X number of rows to the table?

Thanks!
David Somers

 

[bradcccs]

Message off:

DoCmd.SetWarnings False

Messages on:

DoCmd.SetWarnings True