Changing Default Values, Access web application

[WKU]

I have created a production report that is designed as a web app for my employees in the field. I have one table where I enter the "job" and "Scope of Work". Then I want my employees to open their form and when they select their job (which is a lookup value referencing the first table I want the scope of work to appear as a default value in their form. Does that make sense? every job has unique scopes and therefore the scope needs to change. Can someone please help me with this.

[June7]

Is "Scope of Work" an attribute in the job table? Options:

1. multi-column combobox with the related job info as columns of the RowSource, textboxes refer to the columns to display the related info

2. include the jobs table in the form RecordSource, bind textboxes to the job table fields

In both cases, set the job info textboxes as Locked Yes, TabStop No.

[WKU]

I am still extremely inexperienced and I apologize for that but can you walk me through the steps of step 2? I am not sure if I understand what you mean.

[June7]

The form RecordSource would be a query that joins the two tables. The query can be an object (as viewed in the Navigation pane) that is referenced by the form RecordSource property or build the query directly in the form RecordSource (it will be an SQL statement in the property).

Building queries that join tables is basic Access functionality. In this case, the join type would be 'Show all records form {the primary table} and only those records from Jobs that match'.

[WKU]

Ok I am getting there, but maybe you can walk me a little through this. I attached screen shots below to show you what I am seeing.

As you can see I am trying to work on the Scope button. When the job is selected at the top of the sheet it needs to reference the the image below find the matching entry and then cause the scope to show what is in column 1 specific to that job.

Can you show me the information you would put in?

[June7]

The Job combobox would be multi-column. Review http://www.datapigtechnologies.com/f...combobox3.html

Then a textbox would have an expression to reference the column that has the scope (set the textbox as Locked Yes, TabStop No):

=[Job].[Column].(1)

This will NOT save the scope to record. If you do want to save the scope with record so that it would not change even if the scope were modified in the source job record, that will require code.

[WKU]

I understand what you are trying to set up but I am not sure if I can access the properties like in the video because I am working with the web application and it is very reduced.

[June7]

Oh, right, forgot you are working with web database. I've never built one, but seen a few here. I don't have one on hand to try with, but isn't it possible to set textbox ControlSource property to an expression that references another control?

If option 1 won't work then what about option 2?

[WKU]

I really don't know how to even do it in the web app, I suck at access but the web app is just so complicated in my opinion. Have you ever set up step 2 in a web app or do you know how to do it? Your last post was right on the money it just didn't work for this scenario

[June7]

I only know that forms and reports are edited in Layout view by selecting items from the ribbon. Tables are edited from Datasheet view by selecting items from the ribbon. Don't remember about queries.