Has anyone ever done this?

[Guest]

Hello,

I am struggling to link a record to a form.
I am currently making a database for my company.

I have a field name (Project Number) and would like to
link the record entries in that field to a form which
contains more information about the project.

So is it possible to have that record in that cell linked
so that when you click on that cell a form with the
information relating to the project number appears.

Has anyone ever done that before can access do that??

Cheers

 

[Arvin Meyer]

You are looking at this from the wrong direction, Tables are designed as a
repository for data. You don't (or shouldn't) enter data directly into them,
you do that through a form. The form can look like a table (datasheet) but
it isn't since it has events and properties associated with each control
(textbox, combobox, etc.)

Because there are events associated with textboxes, you can use the click
event or any other to open another form with more detail.

Have a look at the NorthWind sample database that came with Access for some
specific methods and the code to do them. Post back with specific questions
and we'll do our best to answer them.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads:
http://www.datastrat.com
http://www.mvps.org/access

 

[Albert D. Kallal]

Sure, if you built a nice user interface, and display the data in a grid,
you can most certainly put a button on that grid of data, and it pressing
that button can open up a new form with details of that one record.

So, remember, when you are building a application, you will build a nice
interface with forms.

The following screen shots shows you what I mean, and there is good ideas in
terms of displaying data with buttons to get more information.

Check out:

http://www.attcanada.net/~kallal.msn/Articles/Grid.htm

If you any questions about the above, you can ask here.....