Restricting number of entries allowed in a seperate form based on prefilled textfield in main form

D

Data

Hello everyone,

I have a question that needs to be answered,

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

That is,
If condition = GPM then displays 2 records to enter data. If
condition = DBT the dispays 6
records or entries to enter data.
(two conditions either GPM or DBT).

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

cmdOrientation_click
If forms!Clients!.condition = GPM then
'code for number of entries in datasheet in orientation form(what
is it?)
If forms!Clients!.condition = DBT then
'code for number of entries in datasheet of orientation form (what
is it?)
End If
End If
 

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