Access 2003 Form Error Message

[TracySHC]

I am currently building a new form in Microsoft Access 2003 over a table. When the Form Wizard reaches where the background can be selected, I receive the error message "Compile error. in query expression 'IIf(IsNumeric(tblStyles.StyleName),AppLoadString(tblStyles.StyleName),tblStyles.StyleName)'." I can only click the OK button, which brings up the next error message: "Invalid use of Null." I am not able to chose a style for the form, because the list of styles is blank. What am I doing wrong?
Please advise,
TracySHC

 

[TheAceMan1]

How are ya TracySHC . . .

[blue]When the Form Wizard reaches [purple]where the background can be selected ...[/purple][/blue]

I've never come across a [blue]form wizard[/blue] where the background can be selected ... Style ... Yes! Be more specific about this as its the reason why your post is slipping thru the cracks.

[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[seaport]

Is that "expression" part of form record source, or part of vb code in a form event?

 

[TracySHC]

TheAceMan1, seaboard,
Yes, I did mean style and not background. The list of styles for the form is empty. There is a directory of styles available on my hard drive, but how do I redirect Microsoft Access 2003 to use this directory? (I haven't had this problem with other Access projects.)
Please let me know if more information is needed, or if I need to clean up my verbiage,
TracySHC