Non-continuous form

[alyon]

Is there a way to make a non-continuous form in Access 2007? If so, please help. :]

[pbaldy]

Sure, just change the default view property to single form, and make sure you're not forcing it into some other mode when you open it.

[alyon]

No, I did that. Maybe I'm not asking what I want right...
When you open the form I want it to be just 1, you can't go previous or next, instead of now how it is 1 of 49... but I already have information in my table.

[pbaldy]

If you just want to add new records, change the Data Entry property of the form to Yes. If you're opening it from some other form and you want to open it with just a specific record displayed, perhaps this:

BaldyWeb wherecondition

[alyon]

I don't think I'm correctly explaining what I want....

I'm not really adding information... but I don't want to disable it incase they need to.

But I have a form it's pretty much made of three different places... each place has a list of people, you pick your person... it fills in the address, phone, etc. in textboxes

Then you hit the command button and and it makes it all print on an envelope...
(the phone numbers and such are because it's an easy way for them to obtain their information)

So I don't need records of this on my form....
But I do on my table, because I need it generate the information...

Is this making any sense?
By the way, I appreciate you trying to help, especially since I don't feel like I'm making any sense.

[pbaldy]

Nah, I can be dense at times. If you don't want the form to display records, does removing the form's record source and the textbox's control sources do what you want? That would make it unconnected to the table except for whatever you might do in your code.

[alyon]

That would work... except that my combo box looks up values in the table and inserts them in textboxes..... So, then that doesn't work... I think I've decided to leave it the way it is. They'll never know the difference.