I need help please.

[richardplr]

Hi,

I have a form that open up another form, please follow the following steps.

1) go to form and click file open MTO No

2) Then click any number appear at the combo box

3) It should open up frm-RPT (SMT) but i alway get this message
The form name "frm-RPT (SMT) is mispell or refer to a format that does
not exist.

Can someone help, where did I do wrong.

Tks

 

[bjackson]

the error message is correct,you have not spelt the forms name correct

try this

highlight the forms name in the database window
press the f2 key
right click and copy the forms name

now paste that name in to your after update event
DoCmd.OpenForm "frm-RPT (SMT)", , , "[ref no] = " & Me.Ref_No

it works fine if the name is spelt correctly
regards
Bjackson

 

[richardplr]

the error message is correct,you have not spelt the forms name correct

try this

highlight the forms name in the database window
press the f2 key
right click and copy the forms name

now paste that name in to your after update event
DoCmd.OpenForm "frm-RPT (SMT)", , , "[ref no] = " & Me.Ref_No

it works fine if the name is spelt correctly
regards
Bjackson

Hi Bjackson

Thank you so much, It work now. May I know why is it so.

I have checked carefully the spelling, there is nothing wrong.

Really salute you.

Thanks

 

[bjackson]

Spelling includes any spaces.Your form name length=13, but in your code
the length of the form name=12, may be you missed a space
Regards
Bjackson