Opening Form

[voltie]

Hi,,

I got a question.. i have a FORM, when i open the form.. my form is filled with related text etc. So i have to click on NEW to clear the form and fill in new information. I want when i clik to the form I want a CLEARED FORM automatically.. so i can fill in the thing i want,

can somebody tell me how to fix this please. thanks

 

[boblarson]

If you don't want to see the previous data, you can just set the form's DATA ENTRY property to YES.

If you do want the other data in there, you can put this in the form's On LOAD event:

DoCmd.RunCommand acCmdRecordsGoToNew

(that goes in the VBA window and not in the property dialog).

 

[voltie]

If you don't want to see the previous data, you can just set the form's DATA ENTRY property to YES.

If you do want the other data in there, you can put this in the form's On LOAD event:

DoCmd.RunCommand acCmdRecordsGoToNew

(that goes in the VBA window and not in the property dialog).

hey Bob Thanks for fast answering my question..

i got the next error: the command or action 'recordsgotonew' isnt available now..

 

[boblarson]

hey Bob Thanks for fast answering my question..

i got the next error: the command or action 'recordsgotonew' isnt available now..

Did you put it in the form's ON LOAD event or the ON OPEN event?

 

[boblarson]

Another possibility -
Actually, if you have no records then you are already on a new record so it can't go to a new record. You may want to modify the code to be this instead:

    If Not Me.NewRecord Then
    DoCmd.RunCommand acCmdRecordsGoToNew
    End If

 

[voltie]

i put in on-load....

 

[voltie]

the same problem with other possibility code..

 

[voltie]

i got other records.. its filled with 10 clients..
is it possible that the problem is that when i load the form its on READ ONLY mode..?

 

[boblarson]

Is your form bound to a table or query?

 

[boblarson]

i got other records.. its filled with 10 clients..
is it possible that the problem is that when i load the form its on READ ONLY mode..?

yes, if the recordset is not updateable then you can't move to a new record.

 

[voltie]

HEY BOB

THANKS!! that was the problem.. thank you again for the CODE
sory for my bad english

 

[boblarson]

No problem!

 

[voltie]

No problem!

i got one other problem now..

when i add new client... which never asked a question or had an issue.. and i search for the new client.. than click on the button ADD QUESTION/ISSUE.. then i get an empty FORM so all textbox/labels are gone...

but when i search for a client who already have had an question/issue and than i click to ADD QUESTION/ISSUE.. then i get all textboxed/labels so i can add all related things...

can you or something tell me the problem please..

 

[voltie]

or i get the error
an expression in argument 6 has an invalid value..?

 

[boblarson]

I'm not sure. I would probably need to actually play with the database, if you can upload it.

(see here for how: http://www.access-programmers.co.uk/forums/showthread.php?t=140587 )

 

[voltie]

its 3mb.. i cant upload it inhere..

 

[voltie]

i cant upload its 3mb...

 

[boblarson]

its 3mb.. i cant upload it inhere..

And you followed ALL of the instructions on the link I gave you (including running

DATABASE TOOLS > COMPACT AND REPAIR

BEFORE Zipping and then seeing how big it is?

 

[boblarson]

Oh, and the maximum size of a Zipped file now on the site is 785.9 Kb instead of the 393Kb it used to be as mentioned in the link I gave you.