table field help please

[darkone]

Hello,

I have a form with all the information I need and it goes into a table called input. There is an additional column there named level, now what I need is for it to lookup the level information from a query and copy and paste it into the column of level in the table of input. How would I do this?

Thanks

 

[john471]

Does this post relate to the Query Help (I think) thread?

Have you considered binding your form to a query rather than directly to the table? This is better practice, and would alow you to call the nTechLevel function (as per the other thread) in the query to display the result in your form. You would probably lock that display control so users can't (try to) change it.

HTH

Regards

John.

 

[darkone]

Yes in reference to another post

I am sorry I didn't get back with you I was out of town for new years. It is in refernce to that query. How do I bind the form to a query instead of a table?

Rick

 

[sonny]

While in design mode, theres a little hand holding a sheet of paper(properties)...on the tool bar...
Click it then click the data tab, theres a arrow next to the entry for record source... change it to your qry name.
Then theres a icon on the tool bar that looks like a sheet of paper only... click it... drag the fields you want onto your form!!

 

[darkone]

Tried

I tried to do the form as binding it to query but them I can't add records at all. I just need it to copy based on the name chosen like Rick tech level 6 to the level column of the input table. The tech level comes from the ntechlevl sql john sent.

Rick

 

[john471]

Rick,

Sounds like you've created a "non updateable" query as the basis for your form.

To learn more about this (I know almost nothing), I would recommend searching this forum for Updateable Query. Pat Hartman is (as with almost any Access related topic anyone can think of) a treasure trove of information on this topic. You can use the advanced search to feature to search on key words and user name.

Here is one example:-
recordset not updatable on my forms

If you do the hard yards now and set your forms up on queries (instead of directly to tables), it will almost certainly pay off in the long run

HTH

Regards

John.