How to implement this---Continuous Form doesn't work

[Mayo123]

I have a continuous form which shows SSN, fName, LName from Table1. Also on the form I have a command button which will be enabled when it finds the same ssn in Table2, otherwise the command button will be dimmed out when there’s no SSN matched in Table2. But the command button doesn’t work the way I want it to: It will be either all enabled for every record or dimmed out for all. How can I work it out. Any help would be appreciated!
Thanks!

 

[spizotfl]

i don't know if it will work that way. access does stuff that is hard to fathom with controls and continuous forms. i have posted in a couple of different forums looking for answers to this type of question, and i don't know if there are any. i would say don't get your hopes up and try to think of another way to present your data.

 

[PHV]

In the detail section of a continuous form an unbound control is the same for all records, dot.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[Mayo123]

So I should give up using Continuous Form?!

 

[PHV]

Not necessarly, but the usual way is to have all fields bound in the detail section.

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886

 

[spizotfl]

probably if you need that functionality out of it. what are you trying to do, maybe we can help come up with an alternate format....

 

[TheAceMan1]

How are ya Mayo123 . . .

You can use a [blue]textbox[/blue] made to look like a command button and [blue]conditional formatting![/blue] (access 2K or higher)

See Ya! . . . . . .

 

[Mayo123]

The Continuous form is bounded, and it shows all the fields I need. On the form_current event, I have some codes to check matching ssn from Table2 in order to make command button enabled or dimmed out. When the command btn is enabled, the user will click on it and it will open up another form.
Dim dbs As Database, rstTable2 As Recordset
dim strCriteria As String
Set dbs = CurrentDb
Set rstTable2 = dbs.OpenRecordset("Table2", OpenDynaset)

strCriteria = "[socsecno] = '" & Me.txtSSN & "'"
rstTable2.MoveFirst

rstTable2.FindFirst strCriteria
If rstTable2.NoMatch Then
cmdTable2.Enabled = False
Else
cmdTable2.Enabled = True
End If