If Then Expressions?

[FoxMan250]

Rethink your terminology. It's not a 'cell', its a control (textbox, combobox, label, etc).

Aren't these three subforms? If you don't want this field to display on form then don't include it in form design.

Sorry, like I said, I havent worked with Access. Really only Excel so I was using the terms I knew.

And the subforms (Upstream/Downstream) pull the information from the same table as the main piece of equipment.

[June7]

Doesn't matter if the data source is same table. If you don't want the field to show then don't bind it to a control on form.

[FoxMan250]

Ah ok. So if I was going to edit the existing fields that are bound to it, could you point me in the right direction?

[June7]

Don't understand the question. You want to modify form design?

[FoxMan250]

Don't understand the question. You want to modify form design?

Sorry, I'm trying. Yes, I believe that is what I want... basically how to add a field to part of the form design.

[June7]

Do you not know how to create and modify objects? Open form in Design view and edit.

[FoxMan250]

Do you not know how to create and modify objects? Open form in Design view and edit.

I dont :/ At least not well enough to feel comfortable that I wont screw up the existing form.

So here's the current form:




I want to add a field just to the side of it like this, but only on that top line like so:





And have that field pull data from this section of the table:

[June7]

Field/textbox in Detail section will display with every record/row of the form. But if there is no data in the other records, does it matter?

[FoxMan250]

Thanks, I'll try that and get back to you if I get hung up. And currently nothing is in there but specific pieces of equipment will be getting text added later.

[FoxMan250]

So I got it thanks to your help! Added the section and it looks great. Only thing I need to do is figure out how to make it stay blank if no text is in the box.

[June7]

If there is no text/data in the field, the textbox should be empty.

Why does it show #Name? error?

[FoxMan250]

Not sure... must be some sort of error. I'll have to google it and see what went wrong.

[June7]

That error means Access can't find the field referenced in ControlSource. So why can't it find the field? Did you modify the form RecordSource to include the new field?

[FoxMan250]

Nope, i didn't. I just typed in the source i wanted it bound to and it still found it.

[June7]

If it finds the field should not have that error.

What is the SQL statement of the form RecordSource? If it is like:

SELECT * FROM tablename;

then the new field will autonatically be discovered because of the wildcard.