How to limit a sub form to one entry

[schltzy99]

Does anyone know how to limit a subform to one entry per record? In a little more detail, I have a form that allows a user to scroll through a list of job applicants, and the subform allows the user to enter information about their salary requirements, work location, etc. Is there anyway to limit one record in the sub form to each record in the main form? Thanks in advance for any assistance.

DS

 

[LittleSmudge]

Yes, put the fields on the main form.


Alternativly,
Set the sub form's Cycle property to "Current Record"
Set the sub form's Navigation Buttons property to "No"

The user then won't be able to change to anything other that the current record. But you'll run into problems creating the record if one doesn't exist etc.


If it is a one-one relationship the salary requirements info should be in the same table as the applicant's other details ( Why split some off and not others )

Then the first option makes a lot more sense.


'ope-that-'elps-your-thining

G LS

 

[schltzy99]

Thanks LS, that should do it.