Blank Form for Data Entry

[Guest]

Hi,

I have my database application completed, and am now setting up my
Switchboard. I have two forms:

1) A "Main" form, which has tabbed subforms. This form lists all jobs
waiting to be completed, and has all the details about the job. You can
scroll through all the jobs to view the details, and you can go to the blank
record to enter a new job.

2) A "List Open Jobs" form, which gives certain basic details about all
jobs waiting to be completed, in Continuous format, and has a command button
which takes you to the details section for that job on the Main form.

On my Switchboard, I will have a link to the Main form, a link to the List
Open Jobs form, and a link to the Reports.

I would like to add a link to a "Enter New Job" form. How do I have this
link open only a blank Main form record? That is, I don't want to display
all the open jobs -- I just want the blank record to appear.

Thanks,

 

[Guest]

Hi, Rosemary.

Open the form, and set its DataEntry property to True:

Forms!YourFormName.DataEntry = True

Hope that helps.
Sprinks

 

[Guest]

Hi,

Thanks -- that worked, but then all the open jobs were hidden.

Should I create a module with the Forms!YourFormName.DataEntry = True in
it? Then I could create one Switchboard entry which would display only the
blank form for Data Entry, and another Switchboard entry which would open the
same form for Edit and also display all open jobs. Is this correct?

Rosemary

 

[Guest]

Yes, that's what I meant. I meant for you to open the form in the Event
Procedure of your Data Entry command button, and set its DataEntry property
to true.

You could have another button that just opens it, allowing you to view and
edit all the records.

 

[Guest]

Hi again --

I got it. I put the code in a macro, and had the macro open the form.
Thanks!

Rosemary