Newbie needs help

[Daryl2106]

Hi,

I have a CourseChangeForm form that pulls data from a StudentEnrollmentTable. It is displaying the Instructor ID but I want it to display a concatenated instructor first and last name. Most sources I consult suggest a combobox for the form but I do not want users to change this field; rather I just want the name displayed. The Instructor field on the form is now a text field.

Thnaks and take care,

Daryl

[aytee111]

Create a query for the record source for your form based on the StudentEnrollmentTable. Then you can make the name field however you want it to display - First & " " & Last, or Last & ", " & First or whatever.

[bigroo]

Daryl,

You can also use within your query the following as well.

Employee Name: IIf(IsNull([Last Name]),IIf(IsNull([First Name]),[First Name]),IIf(IsNull([First Name]),[Last Name],[First Name] & " " & [Last Name]))

Just change Last Name and First Name to your field names.

Thanks

[Daryl2106]

Thanks! That worked just fine.

Another general question: Can you create more than one form on the same querry. Is it ever necessary and should it be done?

I just relized I am listed as an advanced beginner; I think that is very generous

Take care,

Daryl

[aytee111]

There may be a time when you use the same query, such as inquiries, reporting different fields for different purposes. Some might call it laziness, I would call it keeping it simple! Less maintenance in the long run.

[aytee111]

Actually (now that I come to think about it), keep your static queries to a minimum. Rather use the Record Source for the forms and create the queries "on the fly".

[Daryl2106]

...meaning querries that are created and never changed?

[aytee111]

No, click the three ... next to the record source and create a query that way. It doesn't get saved with a query name and therefore there are less queries in your navigation pane.

[Daryl2106]

Thanks. I learned a lot!