Need direction on Form and Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi. I hope I am in the right place! I am new to Access, so bear with me.
I had a programmer design a db for me, with forms, and queries. He is not
available now. I have a form where one field on the form will not allow me
to enter information into it, nor will it display any information in it. The
programmer said that this was a "read only" field, but I think that it is not
set up correctly. The Field is "revision Level" and some of the properties
are: Locked=yes, Filter lookup=db default, Before
Update=[tbTraining_LU]![RevisionLevel]. I am thinking maybe one of these
fields is not set right?

The next problem. In my query, whenever I add a field, "Trl_Name" from my
tbTraining_LU table, it causes the query to be blank. I can add other
fields from this table to my query with no problem. Only this field.

Any help would be appreciated! Again, I am new, so please state some
suggestions to fix it in 'easy' terms.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Unique values in two fields in query 1
Access Command button to look up and copy data from a query to a table 0
calculation in form and subform AfterUpdate 2
Query Question 3
connection between tables and forms 1
Access Query criteria based on other field of the same query 0
acnewrec? 1

Back
Top