Coding of form names 1

[eon5]

Good day,

I have Report names and Form names in a “Listbox”

“Bill of Material”
“Vendor Information” etc.

I only experience the following problem with the Form names and not the Report names.

When I do my coding like:
Forms!VendorInformation!.VendorID.Setfocus
The coding forces me to concatenate “Vendor Information” to “VendorInformation”, this then forces me again to change the “Vendor Information” to “VendorInformation” in the Listbox.

It would be easier and neater for my client to select, “Vendor Information” from the List Box instead of, “VendorInformation”


Any Ideas will be appreciated

Thanks
Theuns

 

[RivetHed]

Why not add a hidden column to the list showing the actual form name and then use that column as the value? In general spaces in names are best to be avoided if at all possible.

 

[TheAceMan1]

How are eon5 . . .

. . . or just remove any spacing before use:

[blue]   Dim frmName As String
   
   frmName = Me![purple][b]ComboboxName[/b][/purple].Column(1)
   frmName = Replace(frmName, " ", "")
   DoCmd.OpenForm frmName[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997
Also faq181-2886

 

[skyline666]

Does Forms![Vendor Information]!VendorID.SetFocus work? Also I assume there isn't a full stop after the '!' before VendorID in your code.

Andrew