Form Design Question

[Diango]

Hey guys, I have an issue with a form that I'm trying to build. I'm a bit new at this so I'm not sure If what I need is possible.

I have a table called student, it has the following fields:

ID, Term, Term_GPA

Example data:

2 200720 3.5
3 200720 3.0
2 200730 3.3

I have a form with textboxes for ID, Term 200720, Term 200730.

My question is, how can I make it so that the form shows each term GPA based on it's corresponding ID? So it would show the ID number on its textbox, the term gpa for 200720, and the term gpa for 200730.

 

[Diango]

Anybody know? Maybe I can write a query based on the ID textbox to show the result directly to the textbox depending on each term.

 

[David Eagar]

Something like? (attached)

 

[Diango]

Well that's the way my table looks. On the form I will have 3 blank textboxes.

First textbox is for ID, the second and third are for Term 200720 GPA and Term 200730 GPA.

So when I enter an ID in the first box and press a button or some event, then the second and third box will automatically get filled with the Term GPA by taking the ID from the first box and based on the Term.

 

[David Eagar]

So more like this one?

 

[Diango]

Yeah! More like that, except it looks like you're using a subform. Instead of that, I thought about just using one form and instead of a grid, using a textbox to show the GPA based on the Term_Code.

 

[David Eagar]

Any particular objections to subforms? Either way, you need a [Forms]![Formname]![id] criteria in your query in the id column. This will pick up the value of the number you enter on the form

 

[Diango]

I guess my question really now comes down to How can I write a query to pickup the ID from the textbox and to show the result on the other textbox?

 

[David Eagar]

As I said (attached) Experiment & see what you can get

 

[Diango]

Cool thanks!