How do you add fields to a field list? 2

[eques4]

Hi

Does anyone know how you can add fields to the field list once the form has been created?

Thanks

Harry

 

[PaulF]

Are you wanting to Add a new Field to a Table, or are you only wanting to add an existing field to your RecordSource for the Form?

PaulF

 

[eques4]

Paul

The latter.

Many thanks

Harry

 

[eques4]

Paul

The latter.

Many thanks

Harry

 

[PaulF]

simply pass some code to change the RecordSource as in this example

Me.RecordSource = "Select EmployeeID, LastName, FirstName From Employees"
Me.Requery



PaulF

 

[eques4]

Paul

Thanks for this. I am afraid my knowledge is still pretty basic at the moment. Where would I write the code.

Out of interest what does the second line do?

Best regards

Harry

 

[PaulF]

I think I might have overlooked the obvious... If you use a Table for the RecordSource of the Form, and all you want to do is show another field... you simply open the Form in Design View, and add a new TextBox Control to the Form. If the Form uses a Query for the RecordSource, you have to alter the Query to show the new Field and also add the new Control on the Form.

And the second part of the code causes the RecordSource to Refresh itself.

Since I'm not sure what your experience level is.. and exactly what you are attempting to do... it might help if you explain a little more what you want to do.

PaulF

 

[eques4]

Paul

I have a Database which displays information on the various buildings maintained by my company. The Database opens up in Form view so that the users can flick through it on a by building basis.

There are no Queries and the Form feeds off a fairly straightforward Table.

However, when I first set up the Database there was no way of knowing all the fields I would need, as there is in theory an infinite stream of information attached to buildings. When I do add a new field to the Table there does not seem to be an easy way of transferring it to the Form.

I am not an IT professional but tend to get database/spreadsheet based exercises assigned to me in the absence of anyone else. I have therefore picked up a large degree of knowledge over the years. However it is all self taught with the result that I can do really advanced things in some areas but not be able to carry out basic functions in others (as I suspect has happened here!).

I may be able to improvise a solution from what you have written above.

Again, many thanks

Harry

 

[scriverb]

Given your last post, PaulF's post concerning opening the report in Design View is the way to go. In detail you can accomplish this by highlighting the report in the DataBase window. Click the Design button. Now maximize the window and you will see all of the controls that make up the design of the form. Open the tool box from the menu or button bar. Select the View menu and select Field List. Now this small window has all of the fields in your Record Source. Scroll down to your two new fields select then and just drag and drop them into the Detail section of the form. Postion them where you want them to be. You probably will have to adjust the tab order so that the user enters data in the correct order. To do this select Tab Order from the View menu. You can highlight the grey box next to your two new field controls and drag and drop them into the correct postition in the tabbing order.

This should give you a detailed start on how to add the items to your form. Post back with questions and issues that you still don't understand.

Bob Scriver
Want the best answers? See FAQ181-2886
Nobody believes the official spokesman... but everybody trusts an unidentified source.
Author, Bagdad Bob???

 

[PaulF]

well, there really isn't an easier way to add one field here and there... you can use the Form Wizard, but once the Form is already made.. it is usually easier to add the additional field by just opening the Form in Design View, and adding the new Control and binding its ControlSource to the new Field.

PaulF