Limiting entries in a data sheet of a seperate form(continued).

D

Data

Thanks so much Duane. Unforunately, the subform is not functioning in
access 2003 on my computer, since not installed.

Another question,

Say in the main form(clients form), textbox(condition field) displays
GPM or DBT.
Instead of subform, user clicks a command button to go to the
orientation form.
This orientation form displays a set amount of records based on the
condition field.

If GPM then displays 2 records to enter data. If DBT the dispays 6
records or entries to enter data.

I am not sure of the code to display in the orientation form,
command click event.

If parent or me.condition = GPM then
'code for number of entries in datasheet in orientation form
If parent or me.condition = DBT then
'code for number of entries in datasheet of orientation form
End If
End If

Also, can you suggest any books for beginning access vba programmers?

Thanks again
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top